Job Description Experienced Mid-Level DBA
Years Of Experience: 2-4 years
Level of Education: Minimum Bachelor’s Degree
Duties and Responsibilities -
Responsible for ensuring availability and performance of the databases that support the system
- Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance
- To proactively monitor the database systems to ensure secure services with minimum downtime
- Responsible for providing trend analysis to the service management team to enable them to make informed decisions regarding resource management
- Responsible for problem escalation to Oracle Development team and third parties as appropriate
- Responsible for improvement and maintenance of the databases to include rollout and upgrades
- Responsible for implementation and release of database changes as submitted by the development team
- Responsible for configuration, synchronization and administration of Oracle Dataguard (DR)
- Responsible for installation, and administration of Oracle Real Application Cluster (RAC)
- Provision MySQL instances, both in clustered and non-clustered configurations
- Ensure performance, security, and availability of databases - Prepare documentations and specifications
- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage, optimize and tweak as necessary
- Collaborate with other teams members and stakeholders Skills / Attributes Required
- Strong Oracle Database Administration experience
- Experience of managing multiple RDBMS on large systems
- Experience of working in a team that delivers a high availability service
- Experience of working in Data Guard environment - Experience of working in RAC environment
- Practical experience in monitoring and tuning a database to provide a high availability service
- Experience of SQL Server is desirable
- Oracle Certification, preferably OCP
- Strong proficiency in MySQL database management
- Decent experience with recent versions of MySQL
- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
- Experience with replication configuration in MySQL
- Knowledge of de-facto standards and best practices in MySQL .
One Call Bpo is the leading Client-Centric Business Process Outsourcing Company, specializing in Mortgage Loan processing, Insurance Claim processing and Data Entry Outsourcing Processing & Transaction processing services. We assist our clients by managing their business processes to world-class standards, while saving 25% to 50% annually and allowing them to focus on much more important activities. To provide a seamless extension of our client's customer relationship management process by being a premier provider of customer acquisition, customer care, and retention services.