Oracle Database Administrator
Date: Dec 31, 2020
Location: KA, IN
Company: ArisGlobal
Role: Oracle Database Adminstrator
Experience: 5 to 10 Years
Job location: Mysore
Shift: Should be flexible
Skills:
- 5+ years as Oracle DBA
- 5+ years as PostgreSQL DBA
- Experienced in migration projects. Specially Oracle to PostgreSQL
- In-depth understanding of relational and dimensional database theory and concepts.
- Significant practical hands-on experience with database administration, backup and recovery, performance tuning and high-availability solutions.
- Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.
- Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL
- Experience with database replication, hot stand-by, clustering, and table partitioning.
- Linux platform familiarity, system resource monitoring and tuning.
- High-level of proficiency with PostgreSQL in a Linux environment
- Previous experience with MongoDB, DynamoDB, and Redis a plus.
- Previous experience with PostgreSQL in the cloud, including Amazon RDS is a plus.
- Working knowledge of Configuration Management systems such as Chef, Ansible, or Puppet.
- Working knowledge of Docker and previous production experience with PostgreSQL or other databases in a Dockerized environment a plus.
Roles & Responsibilities:
- Working in tandem with our engineering teams to identify and implement the most optimal cloud-based solutions for the company.
- Responsible for implementing, managing, and tuning high-availability 24x7 databases.
- Supporting Engineering and Support teams.
- Establish policies and procedures pertaining to data management, security, maintenance and utilization.
- Develop, manage, and test database backup & recovery strategies, verifying data integrity.
- Perform database installations, configurations, upgrades, and migrations.
- Proactively monitor and tune for performance.
- Responsible for capacity planning and recommending paths to account for application growth that are in line with industry best practices.
- Consult with development and architecture teams to help meet continued application growth.
- Define and implement database schema and configurations working with our development teams.
- Database Administration (Oracle, MySQL, Postgre SQL Server, Mongo DB)
- Hands-on experience in AWS Data Migration Services, AWS Schema Conversion Tool
- Hands-on experience in Homogeneous and Heterogeneous Database Migrations
- Hands-on experience in Database Consolidation, Continuous Data Replication.
- Extensive experience in handing DMS, Goldengate and active data guard for replication
- Create and maintain documentation of procedures, schemas and guides for troubleshooting database systems.
- Collaborate on Database Automation activities to improve process efficiency and risk compliance · Drive Stability initiatives by proactively reviewing and addressing Database performance and capacity trends · Effectively participate and guide - 24x7 operational support shift model
- manage high severity database issues impacting revenue applications working cross functionally across leads of infrastructure, network, and application teams · Ensure centralized 24x7 Database Monitoring and Auditing Tools in place and effective in operation
- Experience with Windows, Linux or UNIX operating systems
- Problem management - Perform root cause analysis on trended DB incidents, performance tuning and major outages up through the application stack. Automation Development - Develop automation that can trigger off a variety of industry standard monitoring tools to resolve common issues in the environment or maintain operating levels. (ie. Automatic restart of processes, automated capacity management, etc ) Database Scaling Design - Contribute to the design of scaling the management of an enterprise database environment including high availability deployment, pluggable databases, encryption and more. ,
- Review consistently on the usage of database inventory on-going basis and work on consolidation, migration and deletion of assets associated and ensure savings to IT spend ·
- Research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements.
- Perform review of schema, stored procedures, and other changes to the database DDL.
- Audit for data integrity and consistency across systems.
- Work with data-warehousing and Business Intelligence tools.
- Stay current with industry trends, making recommendations as needed to drive the company to excel.