Technical Specialist - DBA

Core Responsibilities are:

Logical and physical database design

Table, Trigger, Store Procedures, Views design, development and deployment using SQL on Microsoft SQL Server 2000 and 2005

Database configuration and installation planning through implementation and deployment

Responsible to maintain, manage and monitor multiple databases

Database security management and monitoring

Developing database backup and recovery routines

Conducting database performance optimization monitoring and tuning

Database Encryption

Contributing and Establishing Database standards, policies and procedures

Establishing infrastructure procedures and guidelines

Create, Review and produce migration scripts of database objects from development through production environments

Assisting Application Developers for Table, Trigger, Stored Procedure and view development

Working with Configuration Team, Team Leads, QA and several Business Units for smooth database rollout

Off-hours production support is required as and when needed

Qualifications

Proactive, positive attitude, quick learner and must be a strong team player

Strong written and verbal communication skills

Able to work independently with minimal or no guidance

At least 5 years of logical and physical database development experience

5-10 years of writing SQL scripts for database, tables, stored procedures, triggers and views creation and migration. (T-SQL, BCP, DTS etc.)

3-5 years of performing SQL Server production database administration in a clustered 24/7 OLTP environment with an emphasis on tuning and optimizing production databases for high availability & optimum performance

3 years of SQL Server replication and log shipping experience in production environments

Experience with Enterprise Data Modeling techniques and tools such as Erwin

Experience working with both production support and development resources to implement and administer custom .NET and ASP applications. This includes development or execution of production migration scripts and troubleshooting of high availability environments

Strong Database Troubleshooting skills

Strong Microsoft SQL Server 2000 and 2005 experience

Additional Considerations:

Understanding of UML artifacts such as Class Diagrams, Use Cases, Sequence Diagrams, Deployment Diagrams and Activity Diagrams a plus

Understanding of a development process (preferably RUP, MSF, or Agile) a plus

Basic .NET coding skills