Dice is the leading career destination for tech experts at every stage of their careers. Our client, Unisoft Technology Inc, is seeking the following. Apply via Dice today!
Responsibilities:
• Provide technical expertise and support in the use of DBMS.
• Evaluate and recommend available DBMS products to support validated user requirements.
• Define file organization, indexing methods, and security procedures for specific user applications.
• Create and maintain database objects such as tables, views, indexes, constraints, etc. for data platforms and custom applications.
• Develop, implement, and maintain database backup and recovery procedures for the processing environments, ensuring data integrity, security, and recoverability are built into the DBMS applications.
• Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
• Design and develop logical and physical database designs from application requirements.
• Design and implement automation using scripts and database functions.
• Design and implement replication and backups for mission-critical/tier-1 applications.
• Must be proficient in scripting for designing and implementing automation.
Education:
• Bachelor’s Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.
Experience:
• At least 12+ years of experience in Database.
• At least six (6) years of experience in administering on-prem/cloud-based multiuser environments with expertise in planning, designing, building, and implementing complex database systems.
• Experience administering databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging), and production lifecycles in an AWS environment.
• Proven experience in optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring.
• Proficient in scripting and database functions.
• Experience in testing database security and enterprise policy guidelines according to established best practices.
• Skilled in monitoring and maintaining backups for database recoverability for all production databases.
• Must have experience working in the database domain with at least eight (8) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2, with a minimum of two (2) years of EDB PostgreSQL DB.
• Experience with AGILE methodologies is a plus.
Lead DBA ( Leadership, AWS RDS) – Onsite role in MD – inperson interview in MD