PROFESSIONAL SUMMARY:

Highly motivated with good team skills, problem solving skills, data analytics skills and communication skills, maximizing value and minimizing waste, maintaining high customer satisfaction and increasing productivity of the company.

TECHNICAL SKILLS:

Skills: Oracle 9i/10g/11gR2/12c, RAC, Data Guard, ASM, RMAN, OEM Grid 12c/13c, EXPDP/IMPDP SQL loader, SQL developer, TOAD, SQL, PLSQL, AWR, ADDM, Ignite, MS Office, Putty, WinSCP, SSMS, Oracle APEX, Data Analytics, Data Architect/Design, SQL Server

Operating Systems: Linux, Unix, AIX, Sun Solaris, Windows 2003, Windows 2008

Databases: Oracle 12c/11gR2/10g/9i, SQL Server 2008, Netezza

PROFESSIONAL EXPERIENCE:

Database Analyst/Administrator/Architect

Confidential, Columbus, OH

Responsibilities:

• Wear multiple hats as Oracle database Architect/Solutions Architect/Analyst supporting Oracle 12, 3 - node RAC databases and making sure business applications run efficiently 24/7
• As solution architect/database architect working on redesigning the architecture of the current database systems in saving costs and providing cost-effective solution for the business. And we are estimating a savings or more than 100K per year with this new solution.
• Currently working on project to upgrade 12.1 to 12.2 and OEM 12c to OEM13c.
• Involved with business/project teams in a full project lifecycle from conception to implementation of a project

Database Administrator Specialist

Confidential, Columbus, OH

Responsibilities:

• Lead multiple problem solving sessions as part of LEAN management to identify problems within DBA teams to maximize value and minimize waste resulting in higher productivity and customer satisfaction
• As part of LEAN processing involved in detailed documentation of our day-to-day DBA processes for current as well as for future reference
• Involved with business/project teams in a full project lifecycle from conception to implementation of a project
• As Rapid Response Application DBA provide quick response to customer requests and resolve issues as soon as possible and provide high customer satisfaction
• Provide Rapid Response Application DBA support to Oracle, SQL Server, Netezza and DB2 databases
• Refresh data on non-Prod environments from Prod and move application code across environments
• Work along with teams doing yearly Disaster Recovery testing, switching Production databases with Data Guard databases
• Do health check on all databases we support on a regular basis, provide the report to customers and work towards improving health of the databases
• Monitor database performance using tools like Ignite, SQL Monitoring in OEM
• Monitor SQL performance on databases, provide suggestions to customers and work along with customer in resolving performance issues
• Modify shell scripts as required to automate DBA tasks and schedule scripts using scheduling tools like crontab, ESP
• Provide application DBA support to databases for 10g/11g/12C versions, non-RAC and RAC databases and on multiple platforms Unix/Linux/Windows
• Work along with business and make sure database security standards are followed
• Provide support to end users, developers, business by setting up their database accounts, install client software, ODBC setup, JDBC connections, dblinks etc. focusing on customer satisfaction
• Work closely with multiple teams like network admin, storage admin, server admin, business team and other DBA teams in working towards a customer request
• Provide admin support to APEX applications.

Database Administrator

Confidential, Columbus, OH

Responsibilities:

• Administer multiple Oracle databases including versions 9i, 10gR2, 11gR2 in Unix/Linux/Windows platforms.
• Administer and monitor Oracle databases through 11gR2 Grid control.
• Analyze, design, build, test, deploy and upgrade Oracle databases to 11gR2 version and apply latest patches.
• Do capacity planning of databases with business, application teams.
• Migrate databases between environments like AIX, Unix, Linux, Solaris, Windows
• Backup and recovery/refresh/clone databases using RMAN with TSM/TDP and troubleshoot/fine tune RMAN backups.
• Build and administer Data Guard databases for reporting purpose as well as disaster recovery.
• Maintain database data security within SOX standards.
• Provide admin support to APEX applications.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

• Provide database support for multiple RAC databases on ASM, Streams and Grid11g and non-RAC databases.
• Support database versions 10gR2, 11R2 on Linux servers.
• Do ETL of data from non-oracle sources to oracle tables using SQL loader.
• Provide support to end-users from different teams like development, business etc.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

• Provide 24/7 on-call support for multi-terabyte databases version 9i, 10g and 11g through Grid10g.
• Provide production support for multiple databases non-RAC, RAC, ASM, Data Guard and Streams.
• Ensure data and media recoverability from RMAN backups.
• Convert non-ASM to ASM databases and vice-versa.
• Clone Production databases to Development, QA and Training databases based on requests.
• Load and unload data using data pump, export and import into partition tables.
• Set up procedure to audit database regularly to comply with the PCI standards.
• Upgrade and apply Critical Patch Updates to databases and oracle software for security reasons.
• Monitor and tune the database using AWR, ADDM, SQL Tuning Advisor for optimum performance
• Partition tables based on business needs for a better performance.
• Worked on complete project/software life cycle and co-ordinate with different teams to complete projects.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

• Doing Oracle DBA Production Support, to make sure the database is available 24/7
• Backup Production, Development, QA and Training databases everyday using RMAN and NetVault.
• Cloning production databases for Development, QA testing and Training based on requests.
• Upgrade databases as needed to maintain licensing and apply CPU to databases for security requirements.
• Do data pump, export and import for data loading and unloading.
• Create roles, db links, privileges based on the business needs and assign them to the users.
• Manage and Administer Business Objects accounts for developers.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Monitor the database using EM Grid10g.
• Do troubleshooting with database as well as Grid.
• Maintain development databases for the developers and QA testers.
• Refresh Development databases from the Production databases.
• Make sure database was available to the developers 24/7.

Oracle DBA/APEX Developer

Confidential

Responsibilities:

• Administered and monitor Oracle Database 10g servers and Application Server 10g on both Linux and Windows.
• Monitor and administer all the systems and their applications using Grid Control 10g.
• Analyze, design and build databases and/or data marts to store survey data, trawl data and cruise data.
• Handle Data loading using SQL Loader, Export, Import, Data pump utilities.
• Develop SQL, PLSQL Procedures, Triggers and Functions.
• Develop Oracle Apex Forms/Reports for biological scientists to analyze data.
• Maintain Oracle security and maintain high performance at all times in viewing and downloading data from the database.
• Develop web pages using Macromedia Dreamweaver, Fireworks and Adobe Photoshop.
• Expand the database capability to store large images and reports like pdf, gif, jpeg etc
• Create APEX Forms and reports to upload LOBs like pdf, and image files and display LOBs on reports.
• Provide Oracle support to team members and other colleagues.