Oracle Maintenance

Profile Summary:

Over * years of total DBA experience with mix flavors of RDBMS, which includes close to three years in PostgreSQL, MySQL and Oracle DBA experience. Expertise also includes system study, DB conversion, replication, physical/logical designing, testing, trouble shooting, fine tuning, maintenance, backups, DR implementation.

PostgreSQL DATABASE ADMINISTRATOR:

Deep knowledge of PostgreSQL architecture and build HA solutions for PostgreSQL

Experience in administering large, multi-terabyte PostgreSQL databases.

Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours

Maintaining custom vacuum strategies at table and db level

Removing the Index Bloat Concurrently to improve the performance.

Proactively update the latest security patches to database, which are provided by PostgreSQL open source community

Installation, Configuration, Replication & Maintenance of PostgreSQL servers.

Planned and implemented different Backup & Recovery strategies.

Design, build and administer both development and production PostgreSQL application databases on clustered and non-clustered systems on premise and cloud infrastructure

Participated in DBA on call rotation for both PostgreSQL and oracle.

24/7 support of production database services to ensure the highest standards of availability resilience, integrity, security and performance required by our business.

PostgreSQL replication supporting HA, zero-downtime deployments, and development environments.

Experience in systems administration and expert in automation

Experience in debugging, tuning or modifying database internals and want to contribute to the community

Database replication: repmgr, Slony, native streaming replication

Troubleshooting excessive server load issues and providing solutions.

MYSQL DATABASE ADMINISTRATOR:

Ensured MySQL servers run at optimal health.

Implemented of comprehensive backup and database replication solutions.

Collaborated and maintained working relationships with appropriate technology vendor.

Installed various versions of MySQL across multiple environments.

Installation, configuration and operational management of MySQL servers in High Availability Environment

Business Continuity Planning (BCP) and capacity planning

ORACLE DATABASE ADMINISTRATOR:

Extensive knowledge on database administration for Oracle 10g and 11g,12c experience in very large scale database environment and mission critical large OLTP and OLAP systems.

Involved with installation and maintenance of ORACLE 10g RAC/oracle 11g /12c RAC and standby database for High Availability and Disaster Recovery purpose.

Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.

Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.

Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.

Good experience in writing/editing UNIX Shell Scripts.

Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 10g to 11g and 11g to 12c

Proficient in raising SAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.

Educational Background

MCA (Master in Computer Application) from Sikkim Manipal University India.

B.Sc. in Electronics from Ewing Christian College Allahabad

HSC from K.V. New Cantt. Allahabad India.

SSC from K.V. New Cantt. Allahabad India.

Designation

Database Administrator

Organization

Client

Onelogin INC.

Onelogin INC

Period

Oct, 2017 – Till Date

Handling the AWS Instances.

Strong understanding of distributed service architecture.

Ability to provide accurate engineering effort estimates in a dynamic environment.

Experience troubleshooting in production environments.

Working on Upgrading from PostgreSQL 9.5 to PostgreSQL 10.

Implemented SSH two-factor authentication across entire infrastructure, working with engineering teams to provide a pain-free two-factor experience utilizing Yubikey devices.

Working knowledge of Cassandra Database and MongoDB.

Working knowledge of Docker Containers

Seamlessly transitioned AWS infrastructure from EC2-Classic to VPC, overhauled AWS accounts to follow latest security best practices, reduce AWS costs by over 30%, and wrote documentation.

Responsibilities included designing and developing new back-end services, maintaining and expanding our AWS infrastructure, and providing mentorship to others on my team.

Designation

Database Administrator

Organization

Client

Apex System Inc.

Twitter Inc.

Period

May, 2017 – Oct-2017

Working with on of very critical product in Twitter Inc MoPub, MoPub Marketplace brings together more than 49,000 apps and 180 DSPs globally, servicing 450 billion monthly app advertisement requests and reaching over 1.5 billion unique devices MoPub provides flexible monetization solutions for mobile publishers around the globe. Today, publishers and app developers use MoPub’s trusted platform to drive maximum revenue for every ad impression and control their user experience, while DSPs and marketers enjoy access to high quality mobile audiences at maximum scale.

Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.

Review database design and integration of systems, and makes recommendations regarding enhancements and/or improvements

Expertise in trouble shooting the database performance issues along the with query optimization.

Provide appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.

Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.

Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.

Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.

Designation

IT – Database Adminstrator

Organization

Client

Vidhya Hospital & Trauma Center

Vidhya Hospital & Trauma Center

Period

Aug, 2012 – Oct-2016

Roles and Responsibilities

Setup PostgreSQL for High Availability and Disaster Recovery.

Planned and implemented data backup, recovery and security procedures.

Implementation of various tools like Nagios, pgBadger, pgAdmin, EMS SQL Manager, pgPool-II, PEM, OPM just to name a few.

Performing regular health checks on database servers.

Designation

Database Administrator (PostgreSQL)

Organization

Client

Espire Info Labs

National Informatics Center (NIC) India

Period

Jan 2012 – Aug 2012.

Roles and Responsibilities

Administer and maintain prod/dev/qa databases.

Create standby and replication instances for HA and Scalability

Follow database sharding principles for large distributed systems

Perform database tuning, performance monitoring and capacity planning

Manage user administration and capacity planning.

Able to work non-standard office hours to meet critical maintenance and release schedules

Management and maintenance of backups and recovery procedures.

Installation and maintenance of database server, replication and client environments

Designation

Database Administrator

Organization

Client

Livia Legal Pvt Limited

Livia Legal Pvt Limited

Period

May-2011 – Dec 2011.

Roles and Responsibilities

Responsible for 24/7 availability of all database services.

Played role of team member as well as an independent individual contributor.

Experience in working closely with developers and QA teams for different releases.

Working closely with development teams on implementing and optimizing development processes.

Handled large production/stage releases.

Configured Standby server (warm standby/Hot standby/Streaming replication).

Performing and monitoring regular DBA activities. like (creating backups/restore).

Migrating Data from Oracle to PostgreSQL databases by using Foreign Data Wrapper

Designation

Database Administrator (ORACLE 9i,10g)

Organization

Client

Accenture India Pvt Limited

AT&T

Period

Jan 2009 – May 2011.

Roles and Responsibilities

Performed Database Reorganization(Reorg) regularly for removing row migrations and fragmentation using export and import utilities

Taking care of tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.

Creation of new database links and materialized views and setting up of database jobs for their refreshment.

Experience in setting up Active data guard on production servers

Performed lot of server builds as per the application environmental requirement.

Strengths

Self-Motivation, Hardworking, Adaptive, Ability to plan, design, upgrade and tune Databases for optimal performance with good security management.

Contact this candidate