The SQL Server Engineering team is seeking a highlyqualified Senior SQL Server Database Engineer/Architect to support ourMicrosoft SQL Servers. The Engineer will be responsible for the implementation,configuration, maintenance, diagnosis and performance tuning of critical SQLServer database systems, to ensure the availability and consistent performanceof our corporate applications. This is a "hands-on position requiringsolid technical skills, as well as excellent interpersonal and communicationskills.
The successful candidate will beresponsible for triaging and optimizing application and platform relatedperformance issues. The candidate will also be responsible for ensuringdatabase systems and services are certified for operational readiness (desiredstate configuration, security, health and performance). The candidate must be asubject matter expert on SQL and must able to lead applications and projectsindependently.
- Lead performance monitoring and tuning of assigned projects and communicate with other teams for identifying root cause of all database related issues. Proactively support ongoing maintenance, backup/ recovery, security, auditing and production support.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Design, troubleshoot and optimize SSIS and ETL packages and SSRS reports to meet business needs
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Assist developers with complex query tuning and schema refinement.
- Routinely evaluates/ implements improved methods or processes for administering and maintaining databases and servers.
- Perform scheduled maintenance and support release deployment activities after hours.
- Participate in design and architecture review of the databases and applications. Lead efforts with database topology review and communicate with multiple teams to finalize optimal design for databases and applications.
- Serve as escalation point for troubleshooting minor to major problems on an as-needed basis; often requiring time sensitive response and pro-active communication to different groups within the organization Requirements
- Contribute to the creation of processes, procedures and standards for SQL Server database administration that supports the use of optimal database server resources and performance to minimize potential downtime scenarios
- Defining requirements for automating routine database service delivery processes and collaborating with peers to develop and enhance existing database service delivery automation solutions
- Implements and maintains automated database maintenance plans and backup routines using standard methodologies.