Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 8th Oct 2021
• All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.
• Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
• Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
• 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
• Proactive database monitoring and issue resolution through custom built scripts as well as using PgAdmin/Enterprise manager tools
• Database optimization including performance tuning, query optimization and supportability.
• Actively participate and contribute to projects involving enterprise systems enhancements.
• Implementation and ongoing support of high availability architecture not limited to Active/Active and Active/Passive Clusters
• Work with development project teams to design and implement database solutions to meet business requirements.
• Regular proactive capacity planning and tending reviews of all databases. Producing weekly, monthly management reports.
• Develop and implement Database security polices and procedures, in line with corporate objectives
• Must have 8+ years DBA working experience with PostgreSQL 9.6+ version and good understanding of Oracle Database and Microsoft SQL Server.
• Must be knowledgeable and experienced in managing PostgreSQL on multiple operating systems including Microsoft Windows, Linux (RHEL) and Kubernetes in OpenShift platform
• Experienced in setting up PostgreSQL clusters and supporting databases cluster in on-prem and hybrid cloud environment, and specifically in AWS RDS instance.
• Strong skills in UNIX/Linux Shell Scripting
• Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation.
• Working Knowledge of connection poolers (pgPool and pgBouncer).
• Install, monitor and maintain PostgreSQL software, implement monitoring and alerting.
• Experience in building high-scalable clusters, failover and hot standby solutions based on Maximum available architecture
• Experience in architecting, configuring, setting up Enterprise Fail over manager or similar technology for High availability solution.
• Experience in leading efforts related to system and SQL performance tuning and assisting business process integration with various data sources.
• Ability to work well with development and infrastructure teams in doing database design, changes and enhancement to new and existing applications
• Proven ability to provide High Availability and Disaster Recovery solutions.
• Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
• Strong Troubleshooting Skills
• Ability to maintain a positive attitude while working with high demands and short deadlines that leads to working after hours.
• Must have excellent communications and interpersonal skills