Position: SQL Database Administrator

Location: Pittsburgh, PA

Duration: Contract to hire

Job Description:

Candidate should possess skills that are aligned to the Site Reliability Engineering (SRE) principles with a focus on the discipline specific to this position. SRE is a software engineering approach to Client's SRC Operations. SRE professionals use software as a tool to manage systems, solve problems, and automate tasks. Engineers' focus specializes in improving all aspects of reliability, acting as a conduit between infrastructure and application teams on support issues and improving tools, automation, processes, and software.

Responsibilities | SRE:

• Monitor systems and infrastructure to maintain operational and performance levels
• Rotational on-call responsibilities
• Work closely with other SRC professionals/engineers when issues arise, collabo*** on troubleshooting, and provide consultation/resolution with events/incidents
• Anticipate potential problems before they become impacting and collabo*** to determine solutions
• Gather and analyse metrics from tools and system/application logs to assist in performance tuning, fault finding, and resolution
• Create sustainable systems and services through automation, processes enhancement, tools, and noise reduction
• Build automation to manage the SRC operations and eliminate/minimize manual functions and toil
• Collabo*** with Application/Infrastructure support engineers and operations teams
• Engage in post-incident reviews for improvements and determining the cause to prevent recurrence
• Document work to turn findings into repeatable actions via knowledge articles
• Mentoring and coaching junior engineers

Responsibilities | Discipline:

• Ensure the security, performance, and availability of SQL Server Databases for all Lines of Business
• Responsible for the timely and accu*** completion of other tasks as defined by management
• Support and resolve Database problems
• Plan, execute and manage database implementations and to ensure all security, quality and compliance requirements are met
• Monitor and tune production SQL Database implementations
• Configuration management, performance tuning, and administration of mission critical production databases

Required Knowledge, Skills, and Abilities:

• Provide break/fix as well as proactive system support
• Strong performance tuning and troubleshooting skills
• Must have experience with SQL Profiler and setting up server side traces
• Must have experience with SQL Server AlwaysOn Availability Groups
• Familiar with industry best practice Backup & Recovery concepts
• Strong experience in High Availability and Disaster Recovery st***gies
• Experience with DR/BC implementations spanning multiple production environments
• Installation/Upgrade experience up to SQL Server version 2019
• Experience working with Azure SQL Cloud IaaS and/or PaaS
• Experience with Windows Clustering up to 2019
• Experience with TDE Encryption
• Knowledge of storage system constructs and mount point configurations
• Working knowledge of Stored Procedures, Functions, Triggers
• Strong skills addressing production critical incidents
• Strong troubleshooting and problem-solving skills, with the ability to analyze and resolve complex technical issues
• Excellent communication and interpersonal skills, with the ability to collabo*** effectively with stakeholders at all levels
• Self-motivated and able to work independently or as part of a team, taking ownership of tasks and driving them to completion
• ITIL fundamentals

Education / Experience:

• Bachelor's degree in Engineering, Computer Science, or related field required (or equivalent experience)
• 6 + years of work experience in SQL Server
• Work experience in large client server environments is a plus
• Experience with SQL Server on VMware is a plus
• MCDBA and any related certifications preferred

Indotronix is an Equal Opportunity Employer

---