Infosys

Must be located in the Washington DC area as this is a Hybrid position and does require 2-3 days on-site

Job Summary
We are seeking a highly skilled and experienced Database Engineer - III to join our dynamic team. This role involves designing, developing, and maintaining complex database systems to support enterprise data needs. The ideal candidate will have expertise in data modeling, database design, and ETL processes, with a strong background in SQL, Oracle, Microsoft SQL Server, and related technologies. You will collaborate with cross-functional teams to optimize data workflows and ensure the integrity, security, and availability of critical data assets. This position offers an opportunity to work on innovative projects within a fast-paced environment that values technical excellence and continuous improvement.

SCOPE OF WORK

The position’s SCOPE OF WORK includes the following:

• Install, configure, patch, and upgrade database software PostgreSQL
• Produce detailed technical architecture designs for PostgreSQL solutions.
• Support of production and non-production PostgreSQL databases
• Support of production and non-production databases:

o Correct issues reported in the production system

o Support routine and ad-hoc IT DBA requests

o Update documentation, if required as part of correcting production issues

o Implement and monitor daily and nightly database maintenance jobs

o Monitor, diagnose, and respond to system failure and performance issues, taking appropriate

measures to reduce system downtime and eliminate recurrence of the problem

o Work with USAC technical staff, including network engineers and software developers, to analyze

and improve system performance

o Formulate and implement backup and monthly maintenance procedures for PostgreSQL

Production clusters

o Serve as technical support for any database-related performance or access issue

• Generate ad-hoc and routine reports and define metrics for database health and performance
• Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity

of company databases.

• Leading the team in providing technical support for any database-related performance or access issues
• Perform or affect the performance of all database installations, patches, and planned upgrades.
• Implement data models and database designs, data access and table maintenance codes.
• Resolve database performance issues, database capacity issues, replication, and other database issues.
• Perform database-related development as dictated by departmental or project demands.
• Design and perform data migrations and data transformations as required by application delivery teams or

business customers.

• Develop and maintain documentation, diagrams, and procedures, and complies with the company’s change

management control process.

• Ensure that all database designs adhere to industry best practices.
• Work with application delivery teams during database design.
• Possess substantial knowledge about application and database performance profiles of all databases under

their management.

Available for Public Use

• Represent the IT department in terms of database expertise in coordination with other departments.

QUALIFICATION AND EXPERIENCE:

EXPERIENCE: - PostgreSQL Years of Experience

• Experience with PostgreSQL database Administration 8+ Years
• Production support experience on (PostgreSQL) 8+ Years
• Experience with Puppet deployment tool 3+ Years
• Good understanding of Monitoring Tools such as PEM and TOAD 4+ Years
• Expert level of PostgreSQL knowledge and experience with PostgreSQL 9.5, 5+ Years
• Experience with database characteristics such as table 7+ Years

design, relationships, data partition, efficient indexes, storage allocation,

Capacity planning, etc.

• High Availability Solutions (Master-Master, Master-Slave) and sharing 5+ Years
• Experience in performance tuning and load testing of database 7+ Years
• Knowledge of NoSQL database security concepts, 5+ Years
• Experience in supporting PostgreSQL databases in Cloud (Google, AWS, etc.) 3+ Years
• Linux/Unix platforms and Linux Shell scripting 5+ Years
• Display strong ability in troubleshooting complex issues, 5+ Years
• Experience in performance tuning and load testing of database 7+ Years
• Knowledge of database security concepts 5+Years
• Experience with high availability database and application architectures 3+ Years

NOTE: This is the desired experience.

• EDB PostgreSQL Certification
• You have experience with NoSQL databases, such as Couchbase, MongoDB etc.
• Experience with agile software development such as SCRUM and XP

SPECIAL SKILLS:

• Analytical and problem-solving skills
• Developing and/or creating new or more effective ideas, approaches, etc.
• Developing and executing short-range plans/decisions
• Excellent interpersonal and communication skills
• Ability to exercise sound judgment across a broad range of circumstances

Job Types: Full-time, Contract

Pay: $65.00 - $75.00 per hour

Expected hours: 40 per week

Work Location: Hybrid remote in Washington, DC 20005