Oracle Mysql DBA

Location:

Jefferson City, MO

Posted:

July 13, 2020

Contact this candidate

Resume:

SUMMARY:

Oracle Certified Database Administrator.

13+ years of Experience in IT industry, with 7+ as Senior Oracle database Administrator (Database Creation, Backup methodologies, User management and Space management).

Expertise in:

oOracle 10g/11g/12c/19c Installation, Administration, Upgrade, Monitoring, Database Backup and recovery

o11g,12c RAC configuration and setup and Datagaurd setup (ADG, data guard broker)

oMySQL community edition 5.X, MySQL enterprise edition 5.X Installation, Administration, Migration from community to enterprise edition, Database Backup and recovery, Master slave configuration.

oKnowledge and experience on ITIL process like Incident, Request and Change management, problem management process & compliance process

5+ years of experience in MySQL database and Sql server database Administrator.

3 years of experience in DB2 database Admin, Teradata database Admin and PL/SQL developer.

1 year experience in Azure cloud solution architect level (Azure VM, Storage account, Dashboard creation, Azure Managed SQL)

Experience in MongoDB Installation, Administration and replication set.

Experience in AWS Cloud solution architecture (AWS IAM, EC2, Route 53, VPC, RDS, Cloud watch, SQS, SNS, SWF, CloudFormation and LAMDA function)

Supported 24/7 production and other critical environments.

Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer services.

Database performance tuning, Troubleshooting database issues, proficient in SQL and PL/SQL knowledge

CERTIFICATIONS:

ITIL 2011 Foundation certified

Oracle 11g OCA certified

Oracle 1Z0 – 007 (Introduction to Oracle 9i SQL)

PL/SQL-1Z0-147(Oracle PL/SQL Developer Certified Associate Program)

TECHNOLOGY:

List of software products and tools that I have worked with:

Operating System: Windows /95/98/ /XP

Software Products: HP Unix, AIX, Sun Solaris, Linux

Tools: Oracle9i/10g/11g,12c SQL, PL/SQL, MySQL 5.5,5.6, 5.7, Teradata V2R6, MS SQL Server 2000,2005,2012,2014, DB2 V9.5, Unix Shell Scripting, C,C++, Azure cloud portal Toad, Putty, SQL Server Management Studio, Teradata Administrator, BTEQ, Nagios, BMC Remedy, Foglight, Quest, chef, JIRA

Bamboo, Mysql enterprise monitor, Monyog.

RELEVANT SKILLS:

SKILLS

YEARS

Database Tuning and Maintenance to assure highest level of system availability and performance

Ability to navigate and query a relational database (Oracle) to both develop reports

Create database objects

Database design

Database links and multiple database instances

Database monitoring tools

Database security

Logical database design

Oracle; Knowledge of Oracle including stored procedures and SQL Tuning

Oracle 11g

Oracle 12c

Oracle database security, synonyms, roles, privileges

Oracle RAC 11g,ASM and Data guard 11g,12c,Active Data guard,DGMGRL

Oracle Golden Gate

OEM for Oracle and mysql

Oracle Data Pump (EXPDP/IMPDP), TKProf, Statspack,

Mysql 5.5,5.6,5.7

Azure cloud, AWS

MongoDB

Data Warehouse - Performance tuning

Sun Solaris, UNIX, Linux, and Windows

Oracle data dictionary views

Oracle PL/SQL unit testing

Oracle SQL tuning

Microsoft SQL Server 2012, 2016

PL / SQL

SQL SSAS

SQL SSIS

Microsoft SQL Server Reporting Services

vPROFESSIONAL EXPERIENCE:

365RetailMarkets, KS Mar 2020 to May 2020

Lead MySQL Database administrator

Company:SunPlusData

Responsibilities

Experience in MySQL version from community edition mysql 5.5,Mysql 5.6 and mysql 5.7

Carried out the migration activity from community edition 5.5 to community edition 5.6 from ubuntu 14 to ubuntu 18 server.

Configured replication set up for the critical databases.

Maintaining, creating users and giving permission to them as per user requirement.

Backup and recovery of MySQL databases using Mysqldump utility

Administer the MySQL replication on Master-Slave setup.

Performance tuning and optimization of MySQL Databases and query level using (Innotop,sql profiling)

Managing security of MySQL database with grants and privileges

Resolving some of the common database connectivity issues of MySQL Databases from application server

Footlocker, IL Jan 2019 to Jan 2020

Lead Database administrator – ORACLE / Mysql,MongoDB

Company:TCS

Responsibilities in Oracle:

Creating and maintaining all DBs required for development, testing, staging and production usage

Database installation and configuration of Oracle version 10g,11g and 12c.

Creating and maintaining of CDB’s and PDB’s in 12c environment as per the application requirement

Experienced in database upgrade from 10.2.0.4 to 11g,11g to 12c version

Performed Critical patch apply in all version of oracle DB’s

Designed daily, weekly Backup and Recovery procedures for production, non-production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Supporting performance tuning in Database side as well as capacity planning also performed in DB side and done partition table purging in production and gained around 650GB

Experienced in resolving some of the common DBA issues which includes FRA usage issues oracle ASM disk group full issues

Perform Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate. Experienced in construction of Disaster Recovery (DR) for the required production databases using Data Guard (Physical Standby) and Active Dataguard setup, DGMGRL utility to configuration of data guard setup.

Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.

Experience in planning, installing, configuring, and administering multiple Oracle RAC in Linux and Non RAC databases in Linux/UNIX and oracle ASM.

Used partitions to improve the query performance and manageability.

Responsible for continuous database monitoring and reorganization for ensuring optimum performance.

Expert in SRVCTL and CRSCTL to manager RAC environment activities and Adding or Removing Node from RAC.

Monitored top wait events /top SQLs/ top sessions using OEM.

Experience on Script Programming using Korn shell, bash shell on archiving tolls like tar, gunzip, backup, auditing both external auditing and internal auditing, experience on various UNIX platform like Redhat, AIX

Management of schemas, objects & partitioning the tables & indexes.

Configuring DB Links for users located remotely to connect the database.

Expertise in maintaining Database Security using auditing

Support 24/7 on call rotation.

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Good knowledge on 19c installation, configuration and new features of 19c

Experience in Mysql enterprise edition 5.6, 5.7 and 8.0

Experienced in migration activity from community edition 5.5 to Enterprise Edition 5.7

Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure.

Maintaining, Creating users and giving permission to them as per user requirement.

Backup and recovery of Mysql databases using Mysqldump utility

Experienced in setup Master-Slave replication and troubleshooting issues of replication.

Performance tuning and optimization of Mysql Databases and query level using (Innotop,sql profiling)

Managing security of Mysql database with grants and privileges

Resolving some of the common database connectivity issues of Mysql Databases from application server

Good knowledge on Multi-source replication and multi-master replication

Experience in Installation and configuration of Mongodb version from Mongodb3.X

Experience in setup of replica set for replication configuration, add node and remove nodes in replica set

Database maintenance by taking regular backup of databases on daily basis using mongodump.

Refresh activity from production to development or test environment.

User management

Performed query optimization, understanding query plans and plan cache filters for better performance.

Modifying Priority of nodes to keep specific node Primary all the time.

Adding and removing secondary nodes from replica set.

Resolution of day to day related issues, documentation of Mongo DBA routine tasks.

Created Text Index for querying specific documents with string content.

Monitoring document growth and storage performance by considering multiple factors like write performance, including random access patterns, disk caches, disk readahead and RAID configurations.

Talk Talk Communication UK Jan 2014 to Jun 2018

Lead Database administrator Oracle,SQL server

Company:TCS

Responsibilities

Experience in Oracle version 8i,9i,10g,11g and 12c installation and configuration of databases.

Performed database upgrade from 10.2.0.4 to 11g and from Oracle 9i to 11g.

Performed Critical patch apply in all version of oracle DB’s

l Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Supported firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.

Designed daily, weekly Backup and Recovery procedures for production, non-production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Involved in construction of Disaster Recovery (DR) for the required production databases using Data Guard (Physical Standby) and Active Dataguard setup, DGMGRL utility to configuration of data guard setup.

Familiar with level skills in troubleshooting performance issues using Automated Workload Repository (AWR) and Active Session History (ASH) for optimum performance of database.

Installed and configured of GoldenGate on 11g database for data replication.

Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction issues.

Resolved the issues in conflicts between the target and source database in GoldenGate

Experience in planning, installing, configuring, and administering multiple Oracle RAC in Linux and Non RAC databases in Linux/UNIX.

Used partitions to improve the query performance and manageability.

Responsible for continuous database monitoring and reorganization for ensuring optimum performance.

Expert in SRVCTL and CRSCTL to manager RAC environment activities.

Monitored top wait events /top SQLs/ top sessions using OEM.

l Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement.

Management of schemas, objects & partitioning the tables & indexes.

Configuring DB Links for users located remotely.

Expertise in maintaining Database Security using auditing

Permissions across database objects, running the required development scripts, changing the configuration settings of SQL server etc. by following the change management process

Perform planned fail-over of the SQL server instance from one node to another to balance the load between two nodes

Experience in fixing some of the common database server issues like database in suspect mode, database corruption problems.

Troubleshooting performance issues of SQL server using SQL server activity monitor, task manager, running the scripts.

Configured Maintenance plan for weekly full backup, daily differential backup and an hourly transaction log backup

Managing database security using database logins, users and database and server level roles

Sony Pictures Entertainment Inc March 2011 to Nov 2013

Database Administrator-Oracle/Teradata

Company:TCS

Creating and maintaining all DBs required for development, testing, staging and production usage

Supported Oracle version 8i,9i,10g and 11g

Database upgrade from 10.2.0.4 to 11g and from Oracle 9i to 11g.

Expertise in installation and configuration of Oracle and large databases on Unix Operating System.

Critical patch apply in all version of oracle DB’s

Experienced in schema refresh from production to non-production environment

Database maintenance by taking regular backup of databases on daily basis. Backup involve cold backup and RMAN backup using RMAN utility and logical backup using expdp/impdp utility.

Experience on Oracle enterprise manager OEM.

Familiar with level skills in troubleshooting performance issues using Automated Workload Repository (AWR) and Active Session History (ASH) for optimum performance of database.

Installed and configured of GoldenGate on 11g database for data replication.

Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction issues.

Resolved the issues in conflicts between the target and source database in GoldenGate

Implemented optimal space utilization in table space by avoiding fragmentation.

Used partitions to improve the query performance and manageability.

Responsible for continuous database monitoring and reorganization for ensuring optimum performance.

Management of schemas, objects & partitioning the tables & indexes.

Configuring DB Links for users located remotely.

Expertise in maintaining Database Security using auditing

Resolving tickets daily from database side.

Monitoring daily health check and written many shell scripts to get the health report of the database to mail

Supported 24/7 on-call rotation

Refreshed the Data by using the ARC utilities

Use of Data dictionary tables and views to manage the system.

Backup and restoring the table using Teradata manager.

Performing collect statistics on table as well as column.

Running the application scripts in the production as per the proper approval and testing done in the non-production environment.

Sony Corporation of America March 2009 to Nov 2011

Database administrator-Offshore

Company:TCS

Creating and maintaining all DBs required for development, testing, staging and production usage

Supported Oracle version 8i,9i,10g,11g

Performed Database upgrade from 10.2.0.4 to 11g

Expertise in installation and configuration of Oracle and large databases on Unix Operating System.

Critical patch apply in all version of oracle DB’s

Database maintenance by taking regular backup of databases on daily basis. Backup involve cold backup and RMAN backup using RMAN utility and logical backup using expdp/impdp utility.

Schema refresh from production to development or test environment.

Familiar with level skills in troubleshooting performance issues using Automated Workload Repository (AWR) and Active Session History (ASH) for optimum performance of database.

Implemented optimal space utilization in table space by avoiding fragmentation.

Used partitions to improve the query performance and manageability.

Responsible for continuous database monitoring and reorganization for ensuring optimum performance.

Monitored top wait events /top SQLs/ top sessions using OEM.

Management of schemas, objects & partitioning the tables & indexes.

Configuring DB Links for users located remotely.

Expertise in maintaining Database Security using auditing

Creating and managing the User account with appropriate security.

Creating/maintaining Roles and Profiles and assigning them to users.

GE Real Estate, India Oct 2007 to Feb 2009

Company: TCS

Supporting Application code and creating tables,indexes, PL/sql procedures and Triggers as per the application requirement

Performed unit testing.

Resolved Bugs in Daily basis on the ticket assigned on our queue

Making test cases

Making RCD Document as per the Requirement

Performing User Acceptance Testing before the code send to Production

EDUCATION:

Master of Science (Integrated Course) Government College of Technology, Anna University, Coimbatore. Tamil Nadu. Computer Science

Contact this candidate