Oracle Database Administrator

Job Description

Work Level : Individual Core : Self Motivated, Result Driven Leadership : Decisive, Responsive Industry Type : Information Technology Function : Database Administrator Key Skills : Database Management,Database Programming,MySQL Database Management,Oracle Database,MySQL,PostgreSQL,Microsoft SQL Server,Mongo DB,AWS,AWS CloudFormation Education : Other Education Other: BTech Note: This is a requirement for one of the Workassist Hiring Partner. Roles and Responsibilities ? Should have good knowledge on MySQL, Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch, Cassandra, MariaDB, IBM Db2 ? Able to Choose the right hardware and software for the database, considering factors such as the size of the database, the number of users, and the performance requirements. ? Configure the database for the company's needs, including creating user accounts, granting permissions, and setting up database parameters. ? Perform regular maintenance on the database servers, such as patching the operating system and database software, applying security updates, and backing up the database. ? Monitor the performance and health of the database servers and troubleshoot and resolve any issues that arise. ? Develop and implement backup as well as recovery plans / jobs that meets the company's data recovery requirements, considering factors such as the frequency of backups, the type of backups, and the retention period for backups. ? Develop a recovery plan to restore databases in the event of a failure, considering factors such as the type of failure, the recovery time objective (RTO), and the recovery point objective (RPO). ? Set up database monitoring tools to track key performance metrics, such as CPU usage, disk I/O, memory usage, and query execution times. ? Analyse database performance data to identify trends and patterns, and to identify any areas where performance is suboptimal. ? Investigate the root cause of performance issues, such as slow queries, inefficient indexes, and database bottlenecks. ? Implement tuning solutions to improve database performance, such as rewriting inefficient queries, creating new indexes, and adjusting database parameters. Perform other database maintenance tasks, such as defragmenting indexes and shrinking databases. ? Monitor database usage and audit database activity to identify suspicious activity. ? Develop and implement database security standards and procedures, covering areas such as password management, data encryption, and access control. ? Work with developers to fix database design or code issues that are causing problems. ? Create and maintain database indexes to improve the performance of database queries. Technologies ? Bachelor?s degree in computer science, Software Development, or related field. ? Database Administration Certification in any one of the following databases: Oracle, MS-SQL, MySQL, Postgres ? A minimum of 2 years hands-on experience as a DBA in one or more of the above Database technologies. MS-SQL DBA experience shall be preferred. ? Working knowledge of AWS DB technologies like RDS shall be an added advantage. ? Knowledge of Cloud computing/Elastic computing across virtualized environments shall be a plus. ? Excellent written and verbal communication skills and high level of personal integrity. ? Good organizational skills. Company Description: Workassist is an online recruitment and employment platform based in India, connecting employers with the right talent across diverse industries. By leveraging technology in recruitment, Workassist delivers curated profiles to employers and job opportunities to seekers of all experience levels. With a commitment to enhancing the hiring process, Workassist serves industries such as Banking & Finance, Consulting, Sales & Marketing, Healthcare, IT, Operations, and Legal. Our global reach and adaptability ensure the best matches for both job seekers and recruiters. (Note: There are many more opportunities apart from this on the portal. Depending on the skills, you can apply for them as well). So, if you are ready for a new challenge, a great work environment, and an opportunity to take your career to the next level, don't hesitate to apply today. We are waiting for you!