As a Database Administrator, you will administer, maintain and utilize policies and procedures for ensuring the integrity of the databases.
Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data like linked server issues.
Support production DBA in daily or emergency procedures to resolve issues.
Lead the efforts of installing and maintaining database management software.
Implement Database Change Controls & Service Requests.
Resolve database related trouble tickets assigned to the DBA group.
Experience for performance monitoring and tuning in detail is needed. You will create database objects and maintain their physical organization/relationships.
You will frequently support the data loads into the databases and database refresh/copy.
Ensure that the application, and any enhancements, interact efficiently with the database. Must be able to support/ troubleshoot DTS package and stored procedures
Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities.
Create/ implement database maintenance plan to ensure data integrity.
Manage the on-site backup and recovery process and/or support the off-site backup and recovery teams·
Plan for and execute any required database upgrades and migration (patches etc.)
More than 5 years of experience in the field or related area.
Minimum 4 years of work experience as a Database Administrator for MS SQL Server
Solid skills in database performance factors, monitoring tools and tuning procedures
Strong Database Management skills, including backup and recovery procedures
Knowledge of high availability options like clustering, disaster recovery setup is needed
In-depth experience with MS SQL 2010 or 2012
Windows IIS and Analysis Services
Replication Server Experience needed
Knowledge of fault detection and resolution processes
Candidates must possess a current secret security clearance or higher.