Essential Duties and Responsibilities
The following duties and tasks are essential for this position. Additional responsibilities may be assigned as needed.
- Create and maintain production, reports, and development databases.
- Perform proactive capacity planning to ensure continuous database availability.
- Monitor and tune database performance proactively.
- Install patches to keep databases updated and ensure compatibility with existing applications.
- Plan and implement database backup and recovery procedures.
- Manage encryption on production and non-production databases (SSL & TDE).
- Migrate Non-CDB databases to CDB databases as needed.
- Implement and enforce security measures for all databases (Oracle/SQL Server).
- Establish standards to ensure application design and code maintain integrity, security, and performance. Review database object designs and code for adherence to site standards.
- Evaluate Oracle/SQL Server releases, tools, and third-party products to ensure optimal site performance.
- Plan application releases to minimize impact.
- Provide technical assistance to application development teams in designing database schema objects.
- Administer all database objects, including tables, clusters, indexes, views, sequences, packages, procedures, and database replication.
- Stay updated on database technology trends.
- Perform database patching and upgrades.
- Utilize Unix shell script, Perl script, and Python.
- Work with Oracle SQL/PLSQL.
- Understand REST APIs.
- Apply best practices and DevOps methodologies for always-up, always-available services.
- Troubleshoot errors and performance bottlenecks.
- Analyze the impact of changes to database objects.
- Resolve issues related to databases, applications, and development tools.
- Configure and maintain cross-database replication tools (e.g., Oracle Golden Gate Services) to ensure synchronization of report databases.
- Set up new users and privileges as required.
- Take ultimate responsibility for physical database design.
Qualifications/Requirements
To perform this job successfully, an individual must meet the following requirements:
- Bachelor's degree in Computer Science or a related field.
- 3-5 years of experience as a database administrator.
- Proficient in Oracle or SQL Server.
- Experience with operating system commands and scripting.
- Knowledge of physical database design is preferred.
- Ability to perform both Oracle/SQL Server and operating system performance monitoring proactively.
- Excellent knowledge of database backup and recovery scenarios (Oracle/SQL Server).
- Skilled in using various database monitoring tools.
- Experience with cross-database replication tools (e.g., Oracle Golden Gate) is preferred.
- Strong understanding of database security management.
- Knowledge of database resource acquisition and management.
- Experience in migrating code, database changes, and data through various stages of the development life cycle.
- Proficient in database query optimization.
- Strong communication skills for collaboration with various stakeholders.
Successful Competency Factors
To be successful in this role, the following skills are essential:
- Problem-solving and analytical abilities.
- Effective communication and confidentiality.
- Interpersonal skills for working with staff, senior management, insurance companies, and government and private agencies.
- Ability to multi-task efficiently, professionally, and calmly.