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 :- 30th Jul 2021
• 5+ years of experience in administering PostgreSQL, Oracle,MySQL database, replication, tuning, backup and recovery
• Experience with AWS Aurora Postgres is desired
• Experience handling multi-terabyte databases and high transaction volumes
• Experience handling large table partitioning and sub-partitioning
• Experience with Large Scale database migrations (On-prem to Cloud, On-prem to On-prem)
• Experience helping development team with PostGIS functions and performance tuning of GIS queries
• Must be highly proficient in performance tuning, replication , and proactive monitoring
• Strong expertise in building, maintaining, supporting, troubleshooting, tuning, and monitoring production PostgreSQL database servers
DESIRED SKILLS:
• Understanding of server and storage technology, especially in the area of High Availability
• Knowledge of python scripting and debugging.
• Solid Team player with a positive attitude and team spirit – can work alone and with others
• Ability to mentor team members • Communicates well (oral and written) with customers and management
• Install, configure, and maintain Postgres databases with replication • Install, configure, and maintain MYSQL databases with replication
• Optimize and tune PostgreSQL databases for optimal performance
• Continually improve monitoring, perform database capacity and usage planning
• Write and maintain scripts to automate routine DB tasks
• Troubleshoot database-related application performance issues
• Ensure security and data integrity of all PostgreSQL instances
• Perform routine, periodic and proactive DB maintenance
• Provide off hours support to avoid impact to database availability during normal business hours
• Implement tools to automate database operation and monitoring
• Test restore(master), recovery(point-in-time), replication
• Test cluster failover and disaster recovery
• Implement, document and maintain database roles and security
• Research and evaluate alternatives and recommend solutions for business issues
• Create capacity planning reports based on historical data trends and projected data growth
• Maintain current knowledge of relevant technologies