Amazon Relational Database Service (RDS), Banking Services, Bash Scripting, Communication Skills, Data Recovery, Database Administration, Database Analysis, Database Technology, Detail Oriented, Disaster Recovery, Documentation Standards, High Availability, High School Diploma, Identify Issues, Information Technology & Information Systems, Interviewing Skills, Linux Operating System, Memory Management, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Microsoft Windows Operating System, On Call, Onboarding, Operational Support, Performance Analysis, PostgreSQL, Privacy Controls, Problem Solving Skills, Production Support, Professional Services, Python Programming/Scripting Language, Query Analysis, Query Optimization, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Software Patches, Windows PowerShell, Writing Skills
Position: Senior Database Analyst - SQL DBA & PostgreSQL
Location: Richmond, VA (onsite every other week)
Duration: 12 months
Job ID: 176994
Job Overview:
We are seeking a highly experienced Senior Database Analyst with expertise in SQL Server and PostgreSQL to join our team. The ideal candidate will have over 10 years of hands-on experience in database administration, performance monitoring, query optimization, and backup and recovery operations in enterprise environments. This role requires a deep understanding of database internals, high availability, and disaster recovery solutions. The candidate will work in a hybrid schedule, alternating between one week in-office and one week remote, and participate in a 24x7 on-call rotation.
Responsibilities:
- Provide operational support for SQL Server and PostgreSQL databases across Azure, Linux, and Windows environments.
- Monitor database health and performance, identifying and resolving performance issues at the database and query levels.
- Perform query analysis and tuning to ensure application performance and stability.
- Design, implement, and maintain robust backup and recovery solutions for both SQL Server and PostgreSQL.
- Execute database restores for production support, testing, and disaster recovery scenarios.
- Support and maintain high availability and disaster recovery configurations for minimal downtime.
- Utilize monitoring tools to track performance trends and respond to alerts.
- Perform database patching, upgrades, and maintenance activities.
- Collaborate with application teams and business units to troubleshoot complex database-related issues.
- Ensure compliance with security, audit, and regulatory requirements.
- Maintain high standards of accuracy, documentation, and attention to detail.
- Communicate effectively with technical and non-technical stakeholders.
Qualifications:- 10+ years of hands-on experience as a SQL Server and PostgreSQL DBA in enterprise environments.
- Expertise in database performance monitoring, query optimization, and backup and recovery operations.
- Deep knowledge of SQL Server and PostgreSQL internals, including memory management, indexing, and transaction logging.
- Experience with SQL Server 2012+ and PostgreSQL 11+ on Windows and Linux operating systems.
- Proficiency in high availability and disaster recovery solutions such as SQL Server Availability Groups and PostgreSQL replication.
- Ability to write and optimize T-SQL and PL/pgSQL queries for troubleshooting and performance analysis.
- Scripting experience in PowerShell, Bash, or Python for automating DBA tasks.
- Experience with databases hosted on Azure, AWS RDS, and on-prem environments.
- Minimum of a High School Diploma or equivalency; preference for candidates with experience in regulated industries.
About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com
At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:
- Pay any fee to be considered for, submitted to, or selected for any opportunity.
- Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
- Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.
Pay Range: $50- $53/hr. W2
The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.
If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at legal@pinnacle1.com
#LI-PS4