What are the responsibilities and job description for the SQL DBA position at Techcliff Group?
Must have a very good understanding of MSSQL.
The candidate with be expected to troubleshoot problems. Work with 3rd party vendors to install, configure and support applications installed to infrastructure servers, and work with the Level two SQL DBA.
The candidate with be expected to troubleshoot problems. Work with 3rd party vendors to install, configure and support applications installed to infrastructure servers, and work with the Level two SQL DBA.
Key Responsibilities:
- Troubleshooting Microsoft SQL servers 2008 and newer.
- Monitor and manage server health, functionality and availability related to database servers.
- Install, configure, secure and maintain technical Dev, QA and Production environments.
- Configure and Integrate 3rd party applications and add-ons. Regular review of event logs and performance monitors through the creation of alerts.
- Configure and maintain SQL Server AlwaysOn High Availability
- Provides direct support of Microsoft SQL servers, databases and related enterprise applications.
- Supports internal development, functional technology and project teams on a recurring basis.
- Monitors and optimizes system performance based on Microsoft best practices.
- Implements upgrades, enhancements and fixes following established change management procedures.
- Works with Microsoft Support and other 3rd party vendors in resolution of support issues on as-needed basis.
- Adheres to technical standards, procedures and techniques for the resolution of enterprise database problems to ensure maximum application availability and performance.
- Collaborates with other IT technical engineers, developers and Program Management personnel.
- Experience with Data Warehouses.
- Troubleshooting Oracle 11g and 12c database and servers.
- Install and configure Oracle 11g and 12c
- Participates in scheduled and unscheduled weekend/after-hours system maintenance and support. Performs rotational on-call duty.
DBA qualifications
- Undergraduate degree in Computer Science, Software Engineering, Information Systems or equivalent work experience
- 3 years of experience with Microsoft SQL Server 2008 or later, in a complex enterprise environment
- 3 years of Database Administration experience with the knowledge and ability to perform in all the basic database management skills of database administration