The MS SQL DBA: The DBA is a member of the IT team and is responsible for directly supporting the daily administration of the SQL Server used at our client. DBA will manage and support our Clients Data environment.
Administer, develop, test, or demonstrate databases. Perform many related database functions across one or more teams or clients, including designing, implementing, and maintaining new databases, backup/recovery and
configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.
What youll be doing:
- Provide thought leadership on database architectural design of existing and new systems, database administration, performance monitoring tuning, troubleshooting problems and expansion.
- Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency, improve performance).
- Review, enhance and develop backup and recovery strategies depending on SLA requirements.
- Capacity planning and monitoring database growth.
- Develop, maintain, and administer complex ETL using SQL Server (SSIS).
- Design, maintain and ensure High Availability solutions including replication, clustering etc.
- Design, implement and document Disaster Recovery strategies for critical business servers.
- Perform capacity planning work on Production, UA, QA, DEV and DR environments.
- Research improvements to improve overall system performance.
- Participate in 24 X 7 Support of production environment and mission-critical applications with the Database Technology team on a rotational schedule.
- Communicate and coordinate with other IT teams to successfully resolve support and maintenance issues.
- Develop and enforce database standards and best practices including performance, security, monitoring policies and procedures.
- Other duties as assigned.
What youll need:
- 6 years of experience developing, maintaining, and administering MS SQL Server databases.
- Nice to have Oracle 9g/10g/11g/12c databases experience.
- Experience configuring SQL Server replication required.
- Know-how of cluster management areas, such as adding/bootstrapping/removing nodes, consistency tuning, replication, and multi-DC configuration.
- Experience and knowledge of monitoring, management, capacity planning and compaction strategy
- Experience in database backup and recovery, connectivity and security, and role management.
- Goal driven, highly motivated, with a desire to take the lead and learn new skills.
- Strong customer service skills and passion to work through obstacles to produce results.
- Able to work in a projects-based, team environment.
- Able to be flexible and adapt to change.
- Desired to have MCTS, MCITP, and/or MVP certification.