Database Administrator

• Day-to-Day Activities: Fulfill service tickets assigned by the DBA Lead. Plan and coordinate service requests with stakeholders, including application, infrastructure, security, service providers, and others. Handle necessary service request tickets for both BAU and projects. Provide build and BAU support for various databases, including Oracle, SQL Server, DB2, MariaDB, Yugabyte, and PostgreSQL. Familiarity with ExaCC and management consoles like OEM and OCI is preferred. Exposure to Exadata and other Oracle technologies, such as Oracle Business Suites, is advantageous. Ensure timely closure of all service requests and compliance with change management processes. Respond to, support, and resolve after-hours project activities or incident tickets as necessary.
• Database Design and Implementation: Create and maintain database structures to store and organize data efficiently as required by the respective applications, based on provided scripts and structure information.
• Performance Monitoring and Optimization: Monitor database performance, identify bottlenecks, and make necessary adjustments to ensure optimal performance. Use available tools to run diagnostics and address potential performance issues. Plan periodic tuning exercises with the respective application teams.
• DB Recovery: Develop and implement recovery plans to protect data from loss or corruption and address any recovery-related requests.
• Security Management: Ensure data security by implementing access controls, encryption, and other security measures to protect sensitive information, including periodic hardenings for databases. Decide which patches are suitable for the environment, ensure proper installation of patches, conduct system testing after installation, and complete all relevant documentation.
• Database Maintenance: Perform regular maintenance tasks such as updating database software, applying patches, and optimizing database configurations. Evaluate and determine the necessity of non-security patches.
• Incident Support: Provide support to users by troubleshooting database-related issues, adhering to system criticality-based recovery timelines, and assisting with queries.
• Capacity Planning: Plan for future database growth and ensure the infrastructure can handle increased data loads. Collaborate with various teams, including application, solution architects, service management, and project teams, to ensure optimal capacity availability in the system.
• Compliance and Auditing: Ensure databases comply with relevant regulations and standards and participate in required internal and external audits to maintain compliance
• Participation in Various Forums: Actively participate in meetings that require DBA input. Plan and present DBA BAU activities to relevant stakeholders.
• Documentation: Maintain comprehensive documentation of database configurations, procedures, and policies.
• Takes accountability in considering business and regulatory compliance risks and takes appropriate steps to mitigate the risks.
• Maintains awareness of industry trends on regulatory compliance, emerging threats and technologies in order to understand the risk and better safeguard the company.
• Highlights any potential concerns /risks and proactively shares best risk management practices.

• Bachelor’s degree in computer science, Information Technology, or a related field. Certification in database administration, especially Oracle Certified Professional (OCP).
• Proven experience as a Database Administrator or in a similar role.
• In-depth knowledge of database management systems (DBMS), such as Oracle, SQL Server, MySQL, DB2, Yugabyte, PostgreSQL, and MariaDB.
• Strong understanding of database design, implementation, and maintenance.
• Proficiency in database performance tuning and optimization.
• Experience with backup and recovery procedures.
• Knowledge of data security and encryption techniques.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Proficiency in SQL and database query languages.
• Familiarity with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database).
• Experience with database migration tools and techniques.
• Knowledge of scripting languages (e.g., Python, Bash) for automation.
• Familiarity with database monitoring and management tools.
• Ability to use Oracle Enterprise Manager (OEM) and Oracle Cloud Infrastructure (OCI) for Exadata Cloud at Customer (ExaCC). Soft Skills:
• Attention to Detail: Ability to identify and resolve issues with the database , ensuring eradication of bottlenecks, optimizing queries and DB Resource management
• Analytical Thinking: Strong analytical skills to assess complex problems and develop effective solutions.
• Time Management: Ability to prioritize tasks and manage time effectively to meet deadlines. Understand the need to quickly recover systems in the event it is required.
• Adaptability: Flexibility to adapt to changing requirements and technologies.
• Team Collaboration: Strong teamwork skills to collaborate effectively with colleagues within IT Department and various stakeholders.
• Communication: Excellent verbal and written communication skills to convey technical information clearly.
• Problem-Solving: Proactive approach to identifying and resolving issues promptly.
• Customer Service Orientation: Commitment to providing high-quality support to users and addressing their needs.
• High level of integrity, takes accountability of work and good attitude over teamwork.
• Takes initiative to improve current state of things and adaptable to embrace new changes.

Great Eastern