| Oracle DBA || Irving, TX (Onsite) at Irving, Texas, USA |
| Email: [email protected] |
| From: Ambika, Technosphere Inc. [email protected] Reply to: [email protected] Local candidates required Job DescriptionPrimary Skills Weblogic Administration, Postgres, MongoDB, WebSphere, NGNIX, Apache Tomcat, Oracle DBA, BIZTALK, Oracle PL/SQL, Informix DBA, CFI/MFT, DB2, SQL DBA, Middleware, MySQL As a consultant within the DI team, you will work with our clients to define their digital strategy and execution roadmap, and design and implement differentiated digital solutions to help deliver measurable value. Your responsibilities in this role will include: DBA 8+ years of experience in administering PostgreSQL, Oracle, MySQL database, replication, tuning, backup and recovery Experience with AWS Aurora Postgres is desired. Experience handling multimegabit 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. JOB DUTIES 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. Write python, shell scripting for Data Load, check fallout and report Test restore(master), recovery (point Intime), 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. Keywords: database procedural language |
| [email protected] View all |
| Thu Jan 25 00:14:00 UTC 2024 |