Vacancy expired!
- Provide technical expertise and support in the use of Postgres RDS
- Define file organization, indexing methods, and security procedures for specific user applications.
- Create and maintaindatabaseobjects such as tables, views, index, constraints for data platform and custom applications.
- Develop, implement, and maintaindatabasebackup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the RDS and in line with other platform procedures and processes.
- Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and available/approved 3rd party tools.
- Design and develop logical and physicaldatabasedesigns from application requirements.
- Design and implement automation using scripts anddatabasefunctions.
- Implement replication and backups for mission critical/tier-1 applications in line with platform procedures and processes and RDS best practices.
- Create/enhance and maintaindatabasedesign, naming and other standards and periodically assess compliance to such standards through publishing standard reports
- Provide development and technical support primarily for SQL programming and as needed for Python scripting, to accomplish stated objectives.
- Perform testing and validation to ensure performance and defect free code delivery to meet and exceed requirements. This includes tuning and optimizing developed SQL, guiding developers to optimize and utilize best practices for SQL development.
- Monitordatabaseand related systems performance and support troubleshooting and optimizations as required. Perform debugging ondatabasescripts & program and resolve conflicts.
- Install, configure, and maintain Postgres databases with replication Install, configure, and maintain MYSQL databases with replication
- Write terraform modules required to create postgres on AWS and/or Azure.
- 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 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
- Experience in AWS or Azure.
- Experience designing/managing Postgres, MySQL, Snowflake.
- SQL statement tuning - Reviewing and ImplementingDatabasedesign changes
- Coding (procedures, functions, packages, triggers, etc.)
- Min 5 years of experience in administering PostgreSQL and/or Couch DB, replication, tuning, backup and recovery
- Experience with AWS RDS Postgres is desired
- Experience handling multiterabyte databases and high transaction volumes
- Experience handling large table partitioning and subpartitioning
- Experience with Large Scale database migrations (Onprem to Cloud AWS/Azure)
- 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
- ID: #49460316
- State: Texas Richardson 75080 Richardson USA
- City: Richardson
- Salary: $60 - $65
- Job type: Contract
- Showed: 2023-03-13
- Deadline: 2023-04-30
- Category: Software/QA/DBA/etc