What are the responsibilities and job description for the Senior Database Analyst - SQL DBA & PostgreSQL position at PTR Global?
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:
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 ;br>
At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:
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 . To report any concerns, please email us at
#LI-PS4
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.
- 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 ;br>
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 . To report any concerns, please email us at
#LI-PS4
Salary : $50 - $53