Job
Description
Install, configure, and maintain Oracle databases. In charge of developing and implementing database backups and disaster recovery strategies. Optimize database performance by fine-tuning database settings. Troubleshoot and resolve database-related issues to contribute to continuous improvements. Develop, implement, and manage database security policies and procedures to guarantee a seamless and successful flow of activities. Work closely with team members to guarantee database operation and integrity. Introduce and deploy new database technology. Maintain database reports, visualizations, and dashboards to help existing workflows. Interact with clients to comprehend, design, assess, and analyze customers' wants and requirements and provide technical experience in developing technical, structural, and organizational specifications. Assess the suitability of data for storage and the best way to organize storage. Creates, builds, and integrates complex database systems for internal and external users/clients. Defines, documents, and implements standards and complicated models to monitor and improve the database's capacity and performance. Complex programs are coded, and logical processes are derived on technological platforms. Develops and monitors the implementation of test application code in client-server settings to ensure that software adheres to build management guidelines. Maintains knowledge of and assesses new and developing technologies and tools for field application Reduce database downtime and control parameters to ensure quick query responses. Ensure SLAs and operational KPIs are fulfilled, collaborating with internal and external support departments as needed when large events occur. Primary Skills Proficiency in SQL and SQL server tools Advanced understanding of database security, backup and recovery, and performance monitoring requirements Deep understanding on Golden Gate configuration, tuning and related activities. Having Devops experience like with CI/CD pipelines will be an added plus. Modeling of relational and dimensional data PowerShell and Unix shell scripting abilities are required. Impeccable attention to detail, excellent mathematics, and statistical expertise Strong written and oral communication abilities Bachelor's degree in IT or a similar discipline Knowledge of Linux and Windows Server infrastructures Thorough understanding of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB) Must have a DoD Secret Clearance with SSBI or be able to get one. Key skills RAC (Real Application Clusters) GoldenGate (GG) OEM (Oracle Enterprise Manager) TDE (Transparent Data Encryption) Ansible
