Systems Integration Senior Specialist
About The Position
NTT DATA is seeking a Systems Integration Senior Specialist to work as a Database Administrator with PostgreSQL as the primary focus and Microsoft SQL Server as a secondary platform. The role administers, monitors, optimizes, and supports PostgreSQL databases, while providing secondary support for SQL Server. It covers enterprise database environments across on-premises and cloud platforms, including AWS, Azure, and GCP, with a focus on high availability, performance, security, and operational stability. The position is based in Plano, Texas. NTT DATA notes that work arrangements may vary with client requirements and that in-office attendance near an NTT DATA office or client site may be required for meetings or events, depending on business needs.
Requirements
- 4–6 years of experience, as stated in the position heading.
- Strong expertise in PostgreSQL.
- Working knowledge of Microsoft SQL Server.
- Experience administering enterprise databases across on-premises and cloud platforms, including AWS, Azure, and GCP.
- Experience with PostgreSQL installation, configuration, patching, upgrades, migrations, and version management.
- Experience monitoring and troubleshooting database performance and operational issues.
- Experience with query tuning, execution plan analysis, indexing optimization, and VACUUM tuning.
- Experience with PostgreSQL replication, connection pooling, and backup and recovery solutions.
- Experience supporting high availability and disaster recovery for PostgreSQL.
- Experience developing and optimizing SQL and PL/pgSQL scripts and database objects.
Responsibilities
- Administer, monitor, and maintain PostgreSQL and Microsoft SQL Server databases in production and non-production environments.
- Install, configure, patch, upgrade, migrate, and manage versions of PostgreSQL.
- Manage PostgreSQL deployments on IaaS virtual machines and PaaS managed database services across AWS, Azure, and GCP.
- Monitor database health and troubleshoot performance issues, locking, deadlocks, long-running queries, replication issues, and storage utilization.
- Tune queries, analyze execution plans, optimize indexes, tune VACUUM, and perform routine database maintenance.
- Configure and administer PostgreSQL replication, streaming replication, connection pooling with PgBouncer, and backup and recovery solutions.
- Design, execute, and validate backup and recovery strategies using tools such as pg_dump, pgBackRest, and WAL archiving.
- Support PostgreSQL high-availability and disaster-recovery solutions.
- Perform capacity planning, storage management, and proactive database health assessments.
- Provide secondary administration and troubleshooting support for Microsoft SQL Server environments.
- Develop and optimize SQL and PL/pgSQL scripts, stored procedures, functions, and database objects.
- Automate routine database tasks (the job description text ends mid-sentence after “Automate routine databas”).
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
