DBA Administrator

Offerte di lavoro a Dubai e negli Emirati Arabi. Cercasi DBA Administrator

Location: United Arab Emirates
Job Category: Telecommunications
Ref #: TEL–0186
PostedOn: 5/9/2013
Job Description:
SQL SERVER Production DBA

The solution is a multi–tiered enterprise application which includes a mobile location database with sizes of 50 TB+. This position will be responsible for ensuring optimal performance and proactive maintenance of these databases in production at worldwide customer installations.

Overview of Responsibilities:–

– Lead production database maintenance of all product instances (10 TB … 50 TB+ databases).
– Maintain all database backup and restore verification processes.
– Design and Implement all OLTP & BI databases for all production projects that often exceed 50TB in size for SQL Server.
– Design and Implement Partitions, Partitioned Indexes, Spatial Indexes.
– Analyze and redesign queries resulting in optimal performance.
– Design database schemas, partitions, indexes, stored procedures, triggers, rules, ETLs.
– Design and implement clustered databases.
– Design databases to support business applications ensuring system scalability, security, performance and reliability.
– Review product architecture and specification documents.
– Develop data models for applications, metadata tables, views or related database structures.
– Influence technical and business members at different levels of the organization to ensure data models align to strategic objectives.
– Provide expert data analysis of production data.
– Design partition archival mechanisms, backup mechanisms, bulk data load mechanisms.
– Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
– Collaborate with system architects, software architects, design analysts and others to understand and solve business requirements.
– Adjust necessary query plans and indexes for high performance.
– Implement strategies for server application with respect to OLTP vs. BI workload query access patterns.
– Maintain highly responsive OLTP workload that deals with massive amount of data.
– Help implement a high quality product with very few defects.
– Help implement high quality product that will stay up in production 24 by 7.
Work with the offshore development team.
Experience: 10+ Years
Education: Bachelors Degree
Responsibilities: Overview of Responsibilities

1. Lead production database maintenance of all product instances (10 TB … 50 TB+ databases).
2. Maintain all database backup and restore verification processes.
3. Design and Implement all OLTP & BI databases for all production projects that often exceed 50TB in size for SQL Server.
4. Design and Implement Partitions, Partitioned Indexes, Spatial Indexes.
5. Analyze and redesign queries resulting in optimal performance.
6. Design database schemas, partitions, indexes, stored procedures, triggers, rules, ETLs.
7. Design and implement clustered databases.
8. Design databases to support business applications ensuring system scalability, security, performance and reliability.
9. Reviewproduct architecture and specification documents.
10. Develop data models for applications, metadata tables, views or related database structures.
11. Influence technical and business members at different levels of the organization to ensure data models align to strategic objectives.
12. Provide expert data analysis of production data.
13. Design partition archival mechanisms, backup mechanisms, bulk data load mechanisms.
14. Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
15. Collaborate with system architects, software architects, design analysts and others to understand and solve business requirements.
16. Adjust necessary query plans and indexes for high performance.
17. Implement strategies for server application with respect to OLTP vs. BI workload query access patterns.
18. Maintainhighly responsive OLTP workload that deals with massive amount of data.
19. Help implement a high quality product with very few defects.
20. Help implement high quality product that will stay up in production 24 by 7.
21. Work with the offshore development team.

Skills: Qualifications

1. At least 10–15 years of SQL Server production experience.
2. Must have lead production database efforts on 5–10 production projects already.
3. Expert in Schema design, SSIS, Partitioning, Query plan tuning, Bulk insert, etc.
4. Previous experience working with large databases (at least one terabyte+) is necessary.
5. Ability to implement SQL queries, read a query plan, adjust indexes is required.
6. Ability to design and implement high performance database schemas is required.
7. Must have T–SQL and SSIS skills.
8. BI experience is a big plus.
9. Excellent debugging skills.
10. Knowledge of SQL server spatial is highly desired.
11. Knowledge of stream insight is highly desired.
12. Familiarity with Cloud/SaaS databases is a big plus.
13. Familiarity with Oracle database is helpful.
14. Excellent communication skills.
15. Ability to work independently.
16. Ability to work in a fast paced environment.
17. Able to very effectively work with remote teams.
18. Thorough understanding of production database upgrade/maintenance processes.
19. Thorough understanding of water fall and agile software development processes.

>Read the original post and apply here

Lascia un commento

Il tuo indirizzo email non sarà pubblicato. I campi obbligatori sono contrassegnati *