IT & Telecoms,IT & Telecoms|Database Administrator Jobs

Detailed JD: please find below

Sell Rate: $65-68/hour or 130K

Client Full Address: 300 Fifth Avenue, Pittsburgh, PA 15222.

Remote / WFO / Hybrid: Remote is OK

Hire Type (FTE/Contract): FTE preferable, Contract is OK

Project Duration: 1+ year

Expected Start Date: Immediate

Day 1 Billing Confirmation: Yes

No. of client interviews for this role: 1-2 rounds

Role Summary

We are seeking an experienced PostgreSQL Database Expert to provide enterprise-grade PostgreSQL administration, support, performance tuning, and database reliability services. The individual will be responsible for ensuring the availability, performance, security, and scalability of mission-critical PostgreSQL environments while supporting production, non-production, and disaster recovery systems.

Key Responsibilities

Database Administration & Support

• Administer and maintain PostgreSQL databases across Production, UAT, QA, and Development environments.
• Monitor database health, performance, capacity, and availability.
• Perform proactive issue identification and resolution.
• Manage database upgrades, patching, and version migrations.
• Implement and maintain backup, recovery, and archival strategies.

Performance Optimization

• Analyze SQL queries and execution plans.
• Perform database performance tuning and optimization.
• Optimize indexing strategies, partitioning, and database design.
• Identify and resolve database bottlenecks.

High Availability & Disaster Recovery

• Design and support PostgreSQL HA solutions.
• Configure and maintain replication environments.
• Support failover and disaster recovery testing.
• Ensure RPO/RTO objectives are met.

Security & Compliance

• Configure database security controls and access management.
• Implement role-based access controls.
• Support audit, compliance, and vulnerability remediation activities.
• Manage encryption and data protection requirements.

Incident & Problem Management

• Provide L2/L3 production support.
• Troubleshoot critical database incidents.
• Perform root cause analysis (RCA) and implement preventive measures.
• Participate in on-call support and major incident management.

Automation & DevOps

• Develop automation scripts for monitoring, deployment, backup, and maintenance activities.
• Support Infrastructure-as-Code and CI/CD initiatives where applicable.
• Integrate PostgreSQL monitoring with enterprise observability platforms.

Required Skills

• 10+ years of database administration experience.
• 6+ years of hands-on PostgreSQL administration experience.
• HA/DR, performance tuning, and PostgreSQL migration expertise
• Strong knowledge of:
  • PostgreSQL Architecture
  • WAL, Replication & Streaming Replication
  • Backup & Recovery
  • Performance Tuning
  • Partitioning & Indexing
  • PostgreSQL Security
  • Query Optimization
• Experience with:
  • pgAdmin
  • pgBackRest / Barman
  • Patroni / RepMgr
  • Linux Administration
  • Shell/Python Scripting
  • Monitoring tools (Grafana, Prometheus, Datadog, Splunk, etc.)

Preferred Skills

• PostgreSQL on AWS, Azure, or GCP.
• PostgreSQL migration from Oracle, SQL Server, DB2, or other RDBMS platforms.
• Experience supporting large-scale banking or financial services environments.
• Knowledge of Kubernetes/OpenShift-hosted PostgreSQL deployments.
• Exposure to enterprise data governance and regulatory compliance requirements.

Experience Level

• Lead PostgreSQL DBA / PostgreSQL Support Lead
• 10-15+ years overall IT experience
• 6+ years dedicated PostgreSQL experience

Position Summary
The Aurora PostgreSQL Database Administrator is responsible for secure, reliable, and high-performing database services and migrations from other database engines to Amazon Aurora PostgreSQL-Compatible Edition.
This role combines end-to-end migration delivery, advanced query and workload tuning, and replication and high-availability engineering. The DBA partners with application, DevOps, cloud, infrastructure, security, and service-management teams and supports production.

What You Will Do

Migration and Modernization
• Assess and plan: Inventory source schemas, code, dependencies, data volumes, service-level requirements, and compatibility gaps. Define migration sizing, effort, risks, and strategy.
• Design the approach: Select AWS DMS, DMS Schema Conversion and/or AWS SCT, native PostgreSQL utilities, logical replication, and custom SQL or scripts based on the source platform and downtime target.
• Convert and remediate: Transform schemas, data types, indexes, constraints, views, functions, procedures, triggers, jobs, extensions, and application SQL for Aurora PostgreSQL.
• Build migration pipelines: Configure and tune full-load and change-data-capture tasks, endpoints, replication resources, task settings, and monitoring for large tables, LOBs, throughput, and latency.
• Validate and cut over: Conduct test migrations, data reconciliation, performance and load testing, cutover rehearsals, rollback planning, production cutover, and post-migration stabilization.
• Document and coordinate: Maintain mapping decisions, issue logs, acceptance criteria, runbooks, and handoff documentation while partnering with application owners and technical stakeholders.
Performance and Tuning
• Baseline workloads: Measure database load, latency, throughput, waits, resource use, and growth with CloudWatch Database Insights, metrics, logs, Enhanced Monitoring, RDS events, and workload testing.
• Diagnose bottlenecks: Use EXPLAIN (ANALYZE, BUFFERS), pg_stat_activity, pg_stat_statements, aurora_stat_statements, relevant pg_stat views, lock and wait analysis, and database logs.
• Tune end to end: Optimize SQL, indexes, statistics, execution plans, parameter groups, memory, connections, temporary work, storage and I/O, and writer or reader sizing.
• Maintain PostgreSQL health: Manage VACUUM and ANALYZE, autovacuum, bloat, long-running transactions, transaction ID risk, WAL generation, and table or index growth.
• Prevent regressions: Use controlled testing, plan comparison, workload replay or load testing, and Aurora query plan management with apg_plan_mgmt where appropriate.
• Prove outcomes: Document measurable before-and-after results and recommend scalable, cost-conscious improvements to database configuration, SQL, and application design.
Replication, High Availability, and Recovery
• Aurora Replicas: Configure reader instances, reader endpoints, promotion tiers, failover behavior, read scaling, and replica health or lag monitoring.
• Logical replication: Implement and troubleshoot publications, subscriptions, replication slots, replica identity, WAL settings and retention, initial synchronization, conflicts, and lag.
• Migration replication: Support AWS DMS change data capture and monitor source and target latency, task health, recoverable errors, throughput, and data consistency through cutover.
• Cross-Region resilience: Support cross-Region replicas or Aurora Global Database where used. Test switchovers and failovers and validate application connectivity, RTO, and RPO.
• Recovery readiness: Own backup retention, snapshots, point-in-time recovery, restore testing, disaster-recovery runbooks, and recovery exercises.
Aurora Administration and Operations
• Administer Aurora PostgreSQL clusters, writer and reader instances, endpoints, parameter groups, extensions, backups, snapshots, maintenance, upgrades, capacity, and cost.
• Apply PostgreSQL roles and privileges, AWS IAM, TLS, AWS KMS, AWS Secrets Manager or CyberArk, VPC security groups, audit logging, and access reviews.
• Automate health checks, maintenance, deployments, reporting, and recovery tasks using Python, Bash or shell, SQL, AWS CLI/SDK, and infrastructure-as-code tools.
• Provide incident response, root-cause analysis, controlled production changes, operational documentation, monitoring, and rotational 24x7 on-call coverage as need it.

Required
• Three to five years of database administration or database engineering experience in a medium-to-large production environment.
• Strong hands-on administration of Amazon Aurora PostgreSQL-Compatible Edition, including cluster configuration, parameter groups, monitoring, backup and recovery, upgrades, security, and production support.
• Successful delivery of at least one end-to-end migration from a different database engine, such as Oracle, Sybase, SQL Server, MySQL/MariaDB, Db2, or a comparable platform, to Aurora PostgreSQL.
• Practical experience with AWS DMS full load and change data capture, schema and code conversion, migration troubleshooting, data validation, cutover, and rollback planning.
• Advanced PostgreSQL performance knowledge, including MVCC, locking, query planning, indexing, statistics, VACUUM and autovacuum, WAL, memory and connection management, and query-level diagnostics.
• Hands-on replication experience with Aurora Replicas and PostgreSQL logical replication, including lag monitoring, replication slots, WAL retention, failover, and recovery considerations.
• AWS experience with RDS/Aurora, CloudWatch Database Insights, IAM, KMS, Secrets Manager, VPC and security groups, snapshots, events, logs, and related networking.
• Scripting experience with Python, Bash or shell, and SQL, along with working knowledge of Linux/Unix and AWS CLI/SDK.
• Working knowledge of TCP/IP, DNS, ports, TLS, firewalls, and cloud network connectivity.
• Strong troubleshooting, documentation, communication, teamwork, and customer-service skills.
• Experience following production change, incident-management, security, and operational-control processes.
• Bachelor's degree in computer science, information systems, engineering, or a related discipline, or equivalent practical experience.
Preferred
• Deep source-platform knowledge in Sybase, SQL Server, MySQL/MariaDB, Db2, or another enterprise database engine used in heterogeneous migrations.
• Experience using DMS Schema Conversion or AWS SCT for complex database-code conversion, assessment reports, transformation rules, and remediation planning.
• Experience with Aurora Global Database, cross-Region disaster recovery, RDS Proxy, pglogical, advanced partitioning, or Aurora query plan management.
• Experience with infrastructure as code, Git, CI/CD, AWS CloudFormation, Terraform, and automated database deployment or validation pipelines.
• Familiarity with ServiceNow, Jira, Agile delivery, and structured incident, problem, and change management.
• Knowledge of regulated-environment controls such as HIPAA, SOX, or PCI DSS.
• Relevant AWS, PostgreSQL, or database-administration certification.
Work Expectations
• Support after-hours migrations, cutovers, maintenance, upgrades, recovery tests, and production incidents.
• Manage multiple priorities while maintaining disciplined change controls, clear documentation, and timely stakeholder communication.


Core Toolset at a Glance
Migration and Conversion
AWS DMS full load and CDC; DMS Schema Conversion and/or AWS SCT; premigration assessment; data validation; psql; pg_dump and pg_restore; SQL scripts; logical replication; CloudWatch task metrics and logs.
Performance and Diagnostics
CloudWatch Database Insights; CloudWatch metrics, logs, and alarms; Enhanced Monitoring; EXPLAIN (ANALYZE, BUFFERS); pg_stat_activity; pg_stat_statements; aurora_stat_statements; relevant pg_stat views; apg_plan_mgmt.
Replication, High Availability, and Recovery
Aurora Replicas; reader endpoints; promotion tiers; failover testing; logical replication; publications and subscriptions; replication slots; WAL monitoring; AWS DMS CDC; Aurora Global Database; snapshots and point-in-time recovery.
Automation, Security, and Service Management
Python; Bash or shell; SQL; AWS CLI/SDK; CloudFormation or Terraform; Git and CI/CD; IAM; KMS; Secrets Manager or CyberArk; TLS; ServiceNow or Jira; runbooks; change, incident, and problem management.

We are looking for a SQL Server Database Administrator (DBA):

We are seeking an experienced, hands-on SQL Server Database Administrator (DBA) to support and maintain enterprise-level database environments. This individual will be responsible for ensuring database performance, availability, security, and reliability while working closely with application development, infrastructure, and engineering teams. The ideal candidate will have strong expertise in Microsoft SQL Server administration, performance tuning, troubleshooting, and database optimization. We are looking for someone who can proactively identify issues, improve database efficiency, and support business-critical applications in a fast-paced, highly collaborative environment.

Responsibilities:

• Install, configure, maintain, and administer Microsoft SQL Server databases across development, testing, and production environments.
• Monitor database health, performance, availability, and capacity to ensure optimal operations.
• Manage database backups, restores, recovery procedures, and disaster recovery planning.
• Perform database upgrades, patching, migrations, and routine maintenance.
• Maintain database security, user permissions, access controls, and compliance with organizational standards.
• Analyze and troubleshoot SQL Server performance issues, including slow-running queries, blocking, deadlocks, and resource utilization.
• Optimize SQL queries, stored procedures, indexes, and database configurations.
• Utilize SQL Server monitoring and diagnostic tools to identify performance bottlenecks.
• Review execution plans and recommend improvements to database performance and scalability.
• Proactively identify opportunities to improve database reliability and operational efficiency.
• Partner with application developers, architects, and engineering teams to support database requirements for enterprise applications.
• Assist development teams with SQL query optimization, database design, and troubleshooting.
• Support database deployments, schema changes, and application releases.
• Collaborate with cross-functional teams to resolve production incidents and database-related application issues.
• Provide technical guidance on database best practices, performance, and scalability.
• Support SQL Server high-availability and disaster recovery solutions, including Always On Availability Groups and failover clustering.
• Develop and maintain automation scripts using T-SQL and PowerShell to streamline database administration.
• Ensure database environments follow established security, backup, and recovery standards.
• Participate in production support, incident resolution, and root cause analysis.
• Maintain accurate documentation of database configurations, operational procedures, and troubleshooting processes.

Requirements:

• 5 years of hands-on experience administering Microsoft SQL Server databases in enterprise environments.
• Strong experience with SQL Server installation, configuration, maintenance, and troubleshooting.
• Advanced proficiency in T-SQL, including writing, reviewing, and optimizing complex SQL queries and stored procedures.
• Demonstrated experience with SQL Server performance tuning, indexing, execution plans, and query optimization.
• Strong understanding of backup and recovery strategies, database security, and high-availability solutions.
• Experience supporting production databases and resolving critical performance or availability issues.
• Familiarity with SQL Server Management Studio (SSMS), SQL Server Agent, and database monitoring tools.
• Experience collaborating with application development teams to support database changes and deployments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills and the ability to work effectively across technical teams.

Preferred Skills:

• Experience with SQL Server Always On Availability Groups, replication, and failover clustering.
• Experience with cloud-hosted SQL Server environments, particularly Microsoft Azure or AWS.
• Knowledge of database automation using PowerShell or other scripting tools.
• Familiarity with CI/CD pipelines and database deployment processes.
• Experience with large-scale, high-volume transactional database environments.
• Understanding of database architecture, data modeling, and capacity planning.
• Experience working in Agile development environments.

MongoDB Performance Engineering

• Analyze and optimize slow queries and aggregation pipelines using explain plans, MongoDB Profiler, logs, and performance metrics.
• Design and optimize compound, partial, wildcard, TTL, text, and geospatial indexes.
• Apply Equality, Sort, Range (ESR) indexing principles.
• Identify and eliminate unused or redundant indexes.
• Tune MongoDB WiredTiger cache, eviction, checkpoints, compression, and journaling.
• Analyze read/write performance, latency, throughput, and resource utilization.
• Perform schema and data-model optimization for high-volume workloads.

Sharding & Cluster Operations

• Design and implement MongoDB sharding strategies and shard keys.
• Manage shard distribution, balancer operations, chunks, zones, and hot/jumbo chunks.
• Plan and execute resharding activities.
• Manage replication and high-availability configurations.
• Monitor and troubleshoot large-scale sharded clusters.

Job Description: Bill Rate: $60
Location: remote
Duration: 6 month
Role Title: Senior Oracle DBA
Description:
"Summary
Responsible for administration, reliability, and optimization of Oracle database environments supporting enterprise applications.
Core Responsibilities
• Administer Oracle databases (11g/12c/19c/OCI, etc.)
• Manage patching, upgrades, and lifecycle operations
• Ensure availability and resiliency (e.g., RAC, Data Guard where applicable)
• Perform backup and recovery operations
• Monitor and optimize database performance and resource utilization
• Support production releases and deployments
• Implement security, access controls, and compliance requirements
• Troubleshoot database issues and support incident response
• Collaborate with application teams on schema and query optimization"

SKILLS_REQUIRED
"• Oracle RDBMS (on-prem + OCI/cloud exposure)
• PL/SQL, query optimization
• Oracle HA/DR (RAC, Data Guard)
• Performance diagnostics and tuning"

ESSENTIAL_SKILLS
"• At least 10 years of experience, including work with 30+ TB databases handling 80,000 transactions per second."

EXPERIENCE_RANGE_IN_REQUIRED_SKILLS
10 to 15

"Summary
Responsible for administration, reliability, and optimization of Oracle database environments supporting enterprise applications.
Core Responsibilities
• Administer Oracle databases (11g/12c/19c/OCI, etc.)
• Manage patching, upgrades, and lifecycle operations
• Ensure availability and resiliency (e.g., RAC, Data Guard where applicable)
• Perform backup and recovery operations
• Monitor and optimize database performance and resource utilization
• Support production releases and deployments
• Implement security, access controls, and compliance requirements
• Troubleshoot database issues and support incident response
• Collaborate with application teams on schema and query optimization"

Role Descriptions: Install| configure| upgrade| and patch Oracle Database environments.Create and manage Oracle databases| tablespaces| schemas| tables| indexes| and views.Monitor and optimize database performance through SQL tuning| indexing| and resource management.Implement backup and recovery strategies using RMAN and recovery procedures.Ensure high availability and disaster recovery through Oracle Data Guard| RAC| and failover solutions.Manage database security| user accounts| roles| privileges| and auditing.Monitor database health| storage utilization| and capacity planning.Troubleshoot database errors| performance bottlenecks| and production issues.Configure and maintain Oracle networking components such as Oracle Net Listener and TNS.Perform database migration| cloning| refreshes| and data movement activities.Automate routine administration tasks using Shell Scripts| SQL| and PL/SQL.Support application teams during deployments and release activities.Manage Oracle RAC| ASM| Data Guard| and Multitenant databases (CDB/PDB).Ensure compliance with security| audit| and organizational standards.Prepare and maintain database documentation| SOPs| and operational procedures.Provide 24x7 production support and participate in on-call rotations.Work with infrastructure| application| and cloud teams for database reliability and scalability.
Essential Skills: Install| configure| upgrade| and patch Oracle Database environments.Create and manage Oracle databases| tablespaces| schemas| tables| indexes| and views.Monitor and optimize database performance through SQL tuning| indexing| and resource management.Implement backup and recovery strategies using RMAN and recovery procedures.Ensure high availability and disaster recovery through Oracle Data Guard| RAC| and failover solutions.Manage database security| user accounts| roles| privileges| and auditing.Monitor database health| storage utilization| and capacity planning.Troubleshoot database errors| performance bottlenecks| and production issues.Configure and maintain Oracle networking components such as Oracle Net Listener and TNS.Perform database migration| cloning| refreshes| and data movement activities.Automate routine administration tasks using Shell Scripts| SQL| and PL/SQL.Support application teams during deployments and release activities.Manage Oracle RAC| ASM| Data Guard| and Multitenant databases (CDB/PDB).Ensure compliance with security| audit| and organizational standards.Prepare and maintain database documentation| SOPs| and operational procedures.Provide 24x7 production support and participate in on-call rotations.Work with infrastructure| application| and cloud teams for database reliability and scalability.
Desirable Skills:
Keyword:
Skills: ORACLE SQL~PL/SQL~Unix Shell Scripting and text processing tools~Oracle DBA~Unix / Linux Basics and Commands
Experience Required: 8-10

Your Success is Our Success. Global CI is an award-winning 30-year IT Services company founded on the principles of providing high-quality, value-added technology consulting services. Our vision is to create a better future by improving the lives of the people we serve through emerging technologies. Join us and together we will advance the future of technology services.
Global CI offers competitive compensation and non-salary benefits to all eligible employees.

Opening for a Senior DBA to provide support for database operations and design improvements for a portfolio of on-line & batch applications for a program supporting the Federal Office of Child Support Enforcement.

Duties & Responsibilities include:
· Analyze business and technical requirements to develop and recommend database solutions that support both online and batch Java-based and AWS Glue/Apache Spark-based systems, including troubleshooting batch job performance issues against the database (e.g., deadlocks, long-running transactions, connection pool exhaustion) tied to database connections and transaction isolation levels.
· Coordinate with business and technology teams to define system requirements — program functions, output/input data, and support user acceptance and system testing for database components.
· Collaborate with application teams to design and deploy scalable, high-performance database solutions, including PostgreSQL and MySQL running on Amazon RDS; recommend improvements to existing schemas and data models.
· Create, deploy, and maintain database scripts, stored procedures, tables, triggers, and materialized views, leveraging automation and scripting (Python, Shell, Ansible, and AWS CloudFormation) to streamline deployment and configuration management.
· Manage database operations with minimal oversight including configuration, implementation, upgrades (including blue/green deployments), restores (pg_dump, pg_restore), schema changes, password/user management, failovers, disaster recovery, and database replication.
· Communicate and coordinate database changes and other operations with management, developers, and system users.
· Assess and improve database capacity and performance, including capacity planning, right-sizing RDS instances, storage autoscaling, and proactive resource forecasting.
· Maintain the central repository of data architecture artifacts — data dictionaries, admin procedures, scripts, and security controls.
· Maintain and test backup and recovery strategies for applications and databases.
· Perform troubleshooting, root cause analysis, and issue resolution.
· Monitor database health, transaction activity, and resource utilization (proactive and reactive), using monitoring tools such as Amazon CloudWatch Database Insights.

Qualifications:
· Bachelor’s degree from an accredited college in a related discipline, or equivalent experience/combined education, with 6 - 8 years of relevant professional experience; or 4 - 6 years of relevant professional experience with a related Masters degree. Considered an emerging authority. Experience may be substituted in lieu of degree.
· Advanced scripting expertise including bash and Python for database administration and CloudFormation for deployments.
· Demonstrated experience with developing logical and physical data models, data/information exchange models, standards, or tools in a PostgreSQL database environment.
· Extensive database administration experience with PostgreSQL running on Amazon RDS.
· Database administration experience with one or more of MySQL, Microsoft SQL Server, and Oracle.
· Experience in evaluating data architecture & data models and communicating recommendations to the program team.
· Experience managing database replication and Change Data Capture (CDC) preferably in PostgreSQL using AWS Database Migration Service (DMS).
· Solid understanding of High Availability and Resiliency architecture (Multi-AZ and Multi-Region deployment architecture)
· Advanced experience in a Linux environment.
· Experience in an AWS environment.
· Strong verbal and written communications skills.
· Experience with database security and compliance controls, including FISMA/FedRAMP requirements, encryption at rest and in transit (SSL/TLS), role-based access control (RBAC), and audit logging using pgAudit.
· Advanced expertise with PostgreSQL query performance tuning, including use of EXPLAIN, index design and optimization, and autovacuum configuration.
· Experience with version control (Git) and CI/CD pipelines (e.g., Jenkins, GitHub Actions, GitLab CI, or AWS CodePipeline) for database deployments; familiarity with database migration tools such as Liquibase or Flyway.
· Demonstrated performance leading IT services delivery and achieving service level agreements.
· Strong focus on automation and documentation.

Desired Skills:
· Experience creating and administering AWS Glue databases and Athena tables.
· Experience developing software using other AWS services such as Lambda, Lake Formation, QuickSight, DynamoDB, Redshift, MSK/Kafka, Kinesis, ElastiCache, and OpenSearch.
· Experience with containerization technologies such as Docker or Kubernetes, including running PostgreSQL and MySQL workloads in containerized environments (e.g., Amazon ECS, Amazon EKS) or using RDS Proxy.
· Experience supporting Java and PySpark applications.
· Experience developing and executing Ansible scripts.

All candidates supporting the HHS programs must have lived in the United States at least three (3) out of the last five (5) years prior in order to be considere
Benefits include:

• Comprehensive medical, dental, vision, life, and short & long-term disability insurance + health savings account
• Matching 401k retirement plan + IRA's and Roth IRA's
• Generous paid time off and paid holidays
• Employee recruitment/referral bonus
• Paid community service hours
• Tuition reimbursement
• Employee discounts

At Global Commerce & Information, Inc. we celebrate, support, and are committed to creating a diverse and inclusive environment. We're proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status, or any other legally protected characteristics.
Global Commerce & Information, Inc maintains a drug-free workplace.

15+ years experience in working in IT services organization.

" At least 10+ years of SQL DBA experience covering implementation, production support and project work.

" At least 5+ years of exposure as L3/SME support role.

" Knowledge and Understanding the ITIL process

" In client facing role(s) globally for at least 5 years.

" Excellent communication skills

" On call support for at least 5 years.

" Excellent Documentations skills in MS SharePoint 2010 /2013 Mandatory skills - SQL Server & Cloud administration required skills

" Senior level Microsoft SQL Server DBA with experience in large and critical environments.

" Knowledge of performance tuning at both server level and query level. Candidate must have knowledge of perfmon, SQL Server dynamic management views.

" Knowledge of SQL server internals.

" Knowledge of SQL partitioning and compression

" Hands-on experience on mirroring, replication and Always ON

" Must have automation experience. Good knowledge of scripting. Ability to write T-Sql scripts, Power Shell or Python.

" Excellent knowledge of SSIS packages.

" Hands-on experience on SQL Server Clustering.

" Hands-on experience on Integration Services, Reporting services and Analysis services

" Must have good knowledge in SQL Server permission/security policies

" At least 6 months experience with AWS Cloud RDS

" MySQL knowledge / experience.

" Linux Knowledge

" Experience with SnowFlake

" Must be willing to take responsibility and ownership instead of waiting to be assigned work

Position: SQL DBA L4
Location: Jersey City NJ


15+ years experience in working in IT services organization.
" At least 10+ years of SQL DBA experience covering implementation, production support and project work.
" At least 5+ years of exposure as L3/SME support role.
" Knowledge and Understanding the ITIL process
" In client facing role(s) globally for at least 5 years.
" Excellent communication skills
" On call support for at least 5 years.
" Excellent Documentations skills in MS SharePoint 2010 /2013 Mandatory skills - SQL Server & Cloud administration required skills
" Senior level Microsoft SQL Server DBA with experience in large and critical environments.
" Knowledge of performance tuning at both server level and query level. Candidate must have knowledge of perfmon, SQL Server dynamic management views.
" Knowledge of SQL server internals.
" Knowledge of SQL partitioning and compression
" Hands-on experience on mirroring, replication and Always ON
" Must have automation experience. Good knowledge of scripting. Ability to write T-Sql scripts, Power Shell or Python.
" Excellent knowledge of SSIS packages.
" Hands-on experience on SQL Server Clustering.
" Hands-on experience on Integration Services, Reporting services and Analysis services
" Must have good knowledge in SQL Server permission/security policies
" At least 6 months experience with AWS Cloud RDS
" MySQL knowledge / experience.
" Linux Knowledge
" Experience with SnowFlake
" Must be willing to take responsibility and ownership instead of waiting to be assigned work

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

 

Job Title: Tolling Senior MS SQL DBA

Location(s): Mechanicsville, VA
(Remote)


Job Summary
We are seeking an experienced SQL Server / Cloud Database Administrator to join the Engineering and Operations team. The selected candidate will administer, maintain, and support SQL Server and cloud databases, ensuring database availability, performance, security, and reliability. The role also includes help desk and application support responsibilities.

Responsibilities

• Monitor databases to maintain and ensure database uptime and availability.
• Troubleshoot application and database issues related to connectivity, access, security, and other operational concerns.
• Tune long-running SQL queries and optimize database performance.
• Review and refine existing database tasks and processes to align with team priorities.
• Utilize operating system scripting utilities to support database maintenance, diagnostics, and troubleshooting.
• Review existing database implementations and propose, execute, or direct necessary changes.
• Perform SQL Server installations, including versions 2022, 2025, and later, with failover clustering.
• Administer, maintain, support, and tune SQL Server databases.
• Support SQL clustering, mirroring, and high-availability configurations.
• Install, upgrade, patch, and migrate SQL Server databases.
• Work with large SQL databases and develop complex Transact-SQL queries.
• Support database operations on Windows platforms.
• Work with Azure Cloud and other cloud database technologies.
• Provide help desk and application support as part of the team rotation.
• Apply data modeling principles to database design and implementation.
• Collaborate with engineering and operations professionals to accomplish project goals.
• Communicate clearly and effectively, both verbally and in writing.

Required Qualifications

• At least 2 years of experience working with Microsoft SQL Server databases.
• At least 1 year of experience with Azure, Snowflake, or Databricks; a relevant certification may be accepted in lieu of experience.
• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent skills, knowledge, and work experience.
• Demonstrated ability to communicate effectively using standard requirements and design artifacts.
• Experience with SQL Server clustering, mirroring, and high availability.
• Experience with large SQL databases and Transact-SQL.
• Experience tuning SQL Server databases.
• Experience installing, upgrading, patching, and migrating SQL Server databases.
• Experience working in a Windows environment.
• Ability to work independently, plan and accomplish goals, and manage complex tasks.
• Strong troubleshooting, analytical, and communication skills.

Preferred Qualifications

• Experience with SQL Server 2019 or later.
• Experience with Azure Cloud, Snowflake, and/or Databricks.
• Exposure to SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Knowledge of data modeling principles.
• Experience with SQL Server failover clustering and high-availability configurations.

Additional Requirements

• A fingerprint-based background check is required.
• The successful contractor must continue professional education at their own expense to remain current with applicable technologies.

Skills:

                              Skill Required / Desired Amount of Experience Expertise Rating Move MS SQL Server Database Management Required 2 Years     SQL Server Tuning Required 1 Years     Experience working with SSIS, SSRS & SSAS Desired 1 Years     Coding & debugging Transact SQL Required 1 Years     Expertise in installing, upgrading, patching and migrating SQLServer databases Required 2 Years     DB Administration on Azure Cloud, Snowflake, and/or Databricks Nice to have 1 Years    

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

Onsite/Hybrid preferred - 5800 Northampton Blvd, Norfolk, VA 23502
PostgreSQL DBA

Position Summary

The Aurora PostgreSQL Database Administrator is responsible for secure, reliable, and high-performing database services and migrations from other database engines to Amazon Aurora PostgreSQL-Compatible Edition.
This role combines end-to-end migration delivery, advanced query and workload tuning, and replication and high-availability engineering. The DBA partners with application, DevOps, cloud, infrastructure, security, and service-management teams and supports production.

What You Will Do

Migration and Modernization
•Assess and plan: Inventory source schemas, code, dependencies, data volumes, service-level requirements, and compatibility gaps. Define migration sizing, effort, risks, and strategy.
•Design the approach: Select AWS DMS, DMS Schema Conversion and/or AWS SCT, native PostgreSQL utilities, logical replication, and custom SQL or scripts based on the source platform and downtime target.
•Convert and remediate: Transform schemas, data types, indexes, constraints, views, functions, procedures, triggers, jobs, extensions, and application SQL for Aurora PostgreSQL.
•Build migration pipelines: Configure and tune full-load and change-data-capture tasks, endpoints, replication resources, task settings, and monitoring for large tables, LOBs, throughput, and latency.
•Validate and cut over: Conduct test migrations, data reconciliation, performance and load testing, cutover rehearsals, rollback planning, production cutover, and post-migration stabilization.
•Document and coordinate: Maintain mapping decisions, issue logs, acceptance criteria, runbooks, and handoff documentation while partnering with application owners and technical stakeholders.
Performance and Tuning
•Baseline workloads: Measure database load, latency, throughput, waits, resource use, and growth with CloudWatch Database Insights, metrics, logs, Enhanced Monitoring, RDS events, and workload testing.
•Diagnose bottlenecks: Use EXPLAIN (ANALYZE, BUFFERS), pg_stat_activity, pg_stat_statements, aurora_stat_statements, relevant pg_stat views, lock and wait analysis, and database logs.
•Tune end to end: Optimize SQL, indexes, statistics, execution plans, parameter groups, memory, connections, temporary work, storage and I/O, and writer or reader sizing.
•Maintain PostgreSQL health: Manage VACUUM and ANALYZE, autovacuum, bloat, long-running transactions, transaction ID risk, WAL generation, and table or index growth.
•Prevent regressions: Use controlled testing, plan comparison, workload replay or load testing, and Aurora query plan management with apg_plan_mgmt where appropriate.
•Prove outcomes: Document measurable before-and-after results and recommend scalable, cost-conscious improvements to database configuration, SQL, and application design.
Replication, High Availability, and Recovery
•Aurora Replicas: Configure reader instances, reader endpoints, promotion tiers, failover behavior, read scaling, and replica health or lag monitoring.
•Logical replication: Implement and troubleshoot publications, subscriptions, replication slots, replica identity, WAL settings and retention, initial synchronization, conflicts, and lag.
•Migration replication: Support AWS DMS change data capture and monitor source and target latency, task health, recoverable errors, throughput, and data consistency through cutover.
•Cross-Region resilience: Support cross-Region replicas or Aurora Global Database where used. Test switchovers and failovers and validate application connectivity, RTO, and RPO.
•Recovery readiness: Own backup retention, snapshots, point-in-time recovery, restore testing, disaster-recovery runbooks, and recovery exercises.
Aurora Administration and Operations
•Administer Aurora PostgreSQL clusters, writer and reader instances, endpoints, parameter groups, extensions, backups, snapshots, maintenance, upgrades, capacity, and cost.
•Apply PostgreSQL roles and privileges, AWS IAM, TLS, AWS KMS, AWS Secrets Manager or CyberArk, VPC security groups, audit logging, and access reviews.
•Automate health checks, maintenance, deployments, reporting, and recovery tasks using Python, Bash or shell, SQL, AWS CLI/SDK, and infrastructure-as-code tools.
•Provide incident response, root-cause analysis, controlled production changes, operational documentation, monitoring, and rotational 24x7 on-call coverage as need it.

Required
•Three to five years of database administration or database engineering experience in a medium-to-large production environment.
•Strong hands-on administration of Amazon Aurora PostgreSQL-Compatible Edition, including cluster configuration, parameter groups, monitoring, backup and recovery, upgrades, security, and production support.
•Successful delivery of at least one end-to-end migration from a different database engine, such as Oracle, Sybase, SQL Server, MySQL/MariaDB, Db2, or a comparable platform, to Aurora PostgreSQL.
•Practical experience with AWS DMS full load and change data capture, schema and code conversion, migration troubleshooting, data validation, cutover, and rollback planning.
•Advanced PostgreSQL performance knowledge, including MVCC, locking, query planning, indexing, statistics, VACUUM and autovacuum, WAL, memory and connection management, and query-level diagnostics.
•Hands-on replication experience with Aurora Replicas and PostgreSQL logical replication, including lag monitoring, replication slots, WAL retention, failover, and recovery considerations.
•AWS experience with RDS/Aurora, CloudWatch Database Insights, IAM, KMS, Secrets Manager, VPC and security groups, snapshots, events, logs, and related networking.
•Scripting experience with Python, Bash or shell, and SQL, along with working knowledge of Linux/Unix and AWS CLI/SDK.
•Working knowledge of TCP/IP, DNS, ports, TLS, firewalls, and cloud network connectivity.
•Strong troubleshooting, documentation, communication, teamwork, and customer-service skills.
•Experience following production change, incident-management, security, and operational-control processes.
•Bachelor’s degree in computer science, information systems, engineering, or a related discipline, or equivalent practical experience.
Preferred
•Deep source-platform knowledge in Sybase, SQL Server, MySQL/MariaDB, Db2, or another enterprise database engine used in heterogeneous migrations.
•Experience using DMS Schema Conversion or AWS SCT for complex database-code conversion, assessment reports, transformation rules, and remediation planning.
•Experience with Aurora Global Database, cross-Region disaster recovery, RDS Proxy, pglogical, advanced partitioning, or Aurora query plan management.
•Experience with infrastructure as code, Git, CI/CD, AWS CloudFormation, Terraform, and automated database deployment or validation pipelines.
•Familiarity with ServiceNow, Jira, Agile delivery, and structured incident, problem, and change management.
•Knowledge of regulated-environment controls such as HIPAA, SOX, or PCI DSS.
•Relevant AWS, PostgreSQL, or database-administration certification.
Work Expectations
•Support after-hours migrations, cutovers, maintenance, upgrades, recovery tests, and production incidents.
•Manage multiple priorities while maintaining disciplined change controls, clear documentation, and timely stakeholder communication.


Core Toolset at a Glance
Migration and Conversion
AWS DMS full load and CDC; DMS Schema Conversion and/or AWS SCT; premigration assessment; data validation; psql; pg_dump and pg_restore; SQL scripts; logical replication; CloudWatch task metrics and logs.
Performance and Diagnostics
CloudWatch Database Insights; CloudWatch metrics, logs, and alarms; Enhanced Monitoring; EXPLAIN (ANALYZE, BUFFERS); pg_stat_activity; pg_stat_statements; aurora_stat_statements; relevant pg_stat views; apg_plan_mgmt.
Replication, High Availability, and Recovery
Aurora Replicas; reader endpoints; promotion tiers; failover testing; logical replication; publications and subscriptions; replication slots; WAL monitoring; AWS DMS CDC; Aurora Global Database; snapshots and point-in-time recovery.
Automation, Security, and Service Management
Python; Bash or shell; SQL; AWS CLI/SDK; CloudFormation or Terraform; Git and CI/CD; IAM; KMS; Secrets Manager or CyberArk; TLS; ServiceNow or Jira; runbooks; change, incident, and problem management.

Seeking a Senior MS SQL DBA for a remote long-term contract role with the Commonwealth of Virginia in Mechanicsville, VA.
The SQL Server database / Cloud database administrator will administer and support SQL Server and cloud databases in the Tolling group. Additional help desk and application support responsibilities will be part of rotation with the Tolling team. The selected candidate has:

• Expertise working as a SQL Server DBA
• Expertise working with SQL clustering, mirroring and high availability
• Experience working with large SQL databases
• Expertise in writing Transact SQL
• Experience tuning SQL Server databases
• Expertise in installing, upgrading, patching and migrating SQL Server databases
• Experience working on a Windows platform
• Exposure to SSIS, SSAS, & SSRS
• Experience working with Azure Cloud

The selected candidate will:

• Monitor databases to maintain/ensure database uptime and availability.
• Troubleshoot application/database issues related to connectivity, access, security, etc.
• Tune long running SQL
• Review & refine existing database tasks and processes to better align with agency/group priorities.
• Leverage & utilize O/S scripting utilities in support of database maintenance/diagnosis/support.
• Review the existing database implementation and propose, execute, and/or direct necessary changes.
• Perform SQL Server installations (2022,2025+ w/ failover clustering).
• Support SQL Server databases (administration, support, tuning).
• Knowledgeable of data modeling principles

Be expected to...

• Rely on experience and judgment to plan and accomplish goals.
• Independently perform a variety of complicated tasks.
• Work with a team of Engineering and Operations professionals.
• Communicate clearly and effectively, both speaking and in writing.

Qualifications:

• At least 2 years of experience w/ Microsoft SQL Server database
• At least 1 year of Azure, Snowflake, or Databricks experience (a certification is acceptable in lieu of experience)
• Bachelor's degree in computer science, information systems or other applicable and/or equivalent skills, knowledge and/or work history
• Demonstrated experience in communicating effectively using standard requirements and design artifacts

Desired knowledge of and experience with the following technologies:

• SQL Server 2019+
• Cloud databases (Azure, Snowflake, and/or Databricks)

Special Instructions to Applicants:

• This position requires a fingerprint-based background check.
• The successful contractor will be required to continue education at own expense to stay current with Agency technologies.