Database Administrator

# Database Administrator ## Company Overview *Details about the company, its industry, and culture are not provided.* ## Job Summary The Database Administrator (DBA) is responsible for managing large database estates, ensuring high availability, performance, and security of databases across Unix and Windows platforms. This role plays a critical part in maintaining the integrity of data and providing support for production and non-production environments. ## Responsibilities - Handle large database estates and manage terabyte-sized databases. - Install and administer multiple database versions on Unix and Windows servers. - Design and implement high availability solutions such as Real Application Clusters (RAC), GoldenGate, and Data Guard. - Plan and execute major migrations and upgrades of database systems. - Define and configure disks and disk groups in Automatic Storage Management (ASM) and troubleshoot issues. - Manage databases on Exadata machines, ensuring optimal performance and resource utilization. - Plan and implement backup and recovery strategies based on organizational needs. - Coordinate with database vendors to resolve major incidents and issues. - Automate database refreshes, reorganizations, and backups using RMAN and third-party tools. - Install and configure grid control database monitoring tools, while troubleshooting as needed. - Conduct periodic database performance reviews and recommendations for tuning. - Analyze database environments proactively and make suggestions to application teams regarding improvements. - Develop and troubleshoot shell scripting, SQL, and PL/SQL scripts. - Support production and non-production database environments with 24x7 on-call support. - Maintain Standard Operating Procedures (SOPs) for all database activities. - Identify and mitigate technology-related risks while tracking them effectively. - Provide technical presentations on emerging technologies and suggest relevant training to the project manager. - Offer guidance to L2 and L1 Database Administrators on technical and process-related matters. ## Qualifications - Proficiency in database administration, including installation, configuration, and maintenance. - Experience with high availability solutions such as RAC, GoldenGate, and Data Guard. - Strong skills in Automatic Storage Management (ASM) and Exadata environments. - Familiarity with backup and recovery tools like RMAN. - Knowledge of database performance tuning and troubleshooting techniques. - Competence in shell scripting, SQL, and PL/SQL scripting languages. - Strong analytical and problem-solving abilities. - Effective communication skills for liaising with both technical teams and management. - Experience in managing database security practices. ## Preferred Skills - Experience with cloud database solutions and migrations. - Knowledge of database monitoring tools and practices. - Familiarity with emerging database technologies. ## Experience A specific number of years of experience is not provided, but extensive experience in database management and administration is expected. ## Environment *Details regarding the typical work setting, location, and environmental conditions are not provided.* ## Salary *Salary details are not specified.* ## Growth Opportunities *Opportunities for career advancement within the company are not specified.* ## Benefits *Details about offered benefits are not provided.*