SUMMARY:

• A self - driven professional with more than 8 years’ experience with strong capability to manage and communicate with multidisciplinary teams, make well calculated decisions and multitask with exceptional analytical and organizational abilities
• 4 years in retail industry specializing in complex business problems & “bleeding edge” project design, development, implementation and Migrations, experienced in ERP implementations of Oracle and SAP
• 3 Years of SQL SERVER, 7 Years of Oracle DBA experience and a major implementation of MYSQL for mobile traffic
• Over 6 years working in Development, Database Administration and technical support positions
• Dynamic, self-directed Engineer focused on business requirements, data analysis, Database Administration and project management utilizing ITIL methodologies
• Experienced in installing, configuration of databases, patching, upgrading and setting up of Disaster recovery databases to ensure high availability of databases.
• Experienced in setting up of Backup and maintenance plans across diverse databases
• Experienced in Schema design and Database architectural design and helped in effectively coordinating with diverse vendors for deployment, support and maintenance of databases.
• 5 years’ experience in administering ORACLE RAC 5 node cluster and ASM based databases.
• Experienced in Oracle Streams and replication architecture
• Implemented replication and setup clustering in Oracle, My SQL and SQL Server databases
• Experienced in supporting databases 24*7 during the holiday season and monitored databases using Oracle OEM
• Created plans to automate administration and monitoring of databases
• Tuned queries to increase the performance of databases by providing recommendations to developers
• Skilled at eliciting holistic Business Requirements (system, process & people) and identifying, managing conflicting requirements
• Experienced in creating and rebuilding of Oracle Streams and other replication technologies.
• Adept at analyzing data flow and identifying root cause analysis for problems
• Experienced in implementing SOX compliance and coordinated internal audits across different projects
• Proven results-oriented professional leading projects beyond initial implementation to stable sustainment
• Experienced in moving databases from Client Server Architecture to Cloud
• Programming Languages: PHP, Java, PL-SQL, Python, R, shell scripting, CSS, HTML, JavaScript, JSP, Visual Sales Force
• Database Systems: Oracle 9i, oracle 10g(certified)/ oracle 11g/oracle 12c, MySQL, MS-SQL Server
• Plat Forms: Linux, Microsoft OS, Kali Linux, Fedora
• Cloud Technologies: AWS certified Solution Architect and Docker
• Other Tools and Technologies: Robo FTP, tumbleweed, SQL developer, BR Tools, Visual Studio, MS Project, Net Beans, Eclipse, Oracle OEM, Para soft Virtualizer, Tableau and SOA Test
• A strong problem solver with hands on experience applying extensive business knowledge
• Energetic, self-motivated individual always seeking new challenges

SKILL:

Operating Systems: OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 11.x, Sun Solaris 9.0/10.0 and AIX 5.1, 5.2

Data Bases: Oracle 11gRAC/10gRAC/10g, 9i, 12C and Microsoft SQL server .

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting.

Tools: /Utilities:: RAC, OEM Grid Control, Informatica, Exadata, Golden gate, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Dataguard, VMware and CronTab.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, ASH & ADDM.

Terminal Emulation: Toad, Putty, Telnet, FTP, MobaXterm& PL/SQL.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Charlotte, NC

Responsibilities:

• Created plans to migrate the existing oracle 11g databases and application to an internal cloud based technology
• Analyzed data and migrated certain objects from physical oracle 11g databases to internal cloud based oracle 12c databases
• Monitored databases for performance and helped developers choose optimal plans
• Scheduled and monitored jobs using Autosys for database related transformations
• Created backup plans for objects specific to certain applications and provided support during monthly maintenance and patching of databases.
• Consulted extensively with numerous groups, to take initiatives that could have enterprise impact
• Developed plans for upgrades of oracle 12c and documented it for future reference
• Had an exposure about the AWS cloud and how data could be migrated to the cloud.

Project DBA

Confidential, Richfield, Minnesota

Responsibilities:

• Provided support during holiday seasons which generates 75% of their sales
• Involved in the creation, deployment, documentation and maintenance of database deliverables
• Involved in setting up of backup tasks in Oracle Enterprise Manager 12c and planned for simultaneous patching of data bases across three nodes and 4 node clusters with 10 instances each.
• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment.
• Supported more than 130 production and development databases.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Implemented ASM on RAC and stand-alone databases, Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Migration of database from one server to another server.
• Involved in analysis and implementation of highly complex databases.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Supported Applications HR, Oracle Apps, Enterprise customer care, Data ware housing, Retek, Resa, RMS .
• Performed SRDF and RMAN based database refreshes, implemented Logical and Physical Standby databases
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Daily Health Check Up of the Database using AWR, ADDM.
• Experienced in working in Service Now raised 100+ Changes and incidents
• Supported OMS, Oracle Apps, SAP and People Soft databases
• Experienced in supporting databases of size more than 40 tb and hands on experience using
• Tuned databases for High CPU usage and Memory level bottle necks.
• Creating indexes, gathering stats on tables and pinning better plans to improve performance of the SQL query.
• Checking for blocking sessions or table level locks on databases.
• Resolve lock/latch and resource contention issues during production hours.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Created 13 databases for new in-store implementations in Oracle 11g and Oracle 12 c, devised plans for weekly sync and purge activities
• Mentored 15 employees on the strategy of rebuilding Oracle Streams on oracle 11g databases, system build and applications configuration
• Created plans to apply PSU patched on oracle 11g databases and created methods to automate the same with the help of oracle enterprise manager.
• Used RMAN to configure database backups through OEM jobs and monitored the archive backup jobs to ensure smooth operation of databases
• Created oracle profiles and roles to restrict the user s activity beyond a certain point as a part of SOX compliance.

Database Consultant/Project coordinator

Confidential, McCook, IL

Responsibilities:

• Migrated SAP from DB2 database to Oracle 11g, Oracle 10g database using SAP OSDB migration technique
• Gathered and documented business requirement created plans for communication across multiple stake holders
• Created Work breakdown structure, and documents, to establish technical requirements
• Lead the interface between Vendor and design team during product development and roll-out including design & technical collaboration at all stages
• Created User accounts, Roles and granted required access permissions and privileges to the database based on the applications they are accessing.
• Installed, Configured and Maintained Oracle 10g/11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment.
• Database Refresh from one version to another version.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts. Daily Health Check Up of the Database using AWR, ADDM.
• Performed day to day administrative tasks by analysing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Configured database cloning using RMAN and SRDF
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Created tns entries to be pushed to global offices for applications to connect to oracle 10g and oracle 11g database.
• Created backup plans for oracle 11g and oracle 10g databases across an ambiguous environment
• Coordinated project team of 50 across locations in Australia, USA and India for migration and software development

Database Administrator

Confidential

Responsibilities:

• Installed and Configured 2node RAC on Linux.
• Resolving the conflicts between the target and source database.
• Installed and Configured and maintained oracle 10g and 11g.
• Oracle Grid Control 11g Installation and Configuration.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health check-up of the database using TKPROF, AWR & ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Database Administrator/Infrastructure support

Confidential

Responsibilities:

• Created 25 instances of production databases in Oracle and SQL Server
• Performed SAP Data Refreshes, from production to QA using Shadow imaging
• Customized reports to suit the questions asked by stake holders and served as an internally ITIL SPOC
• Implemented SOX compliance on 100 instances of oracle and SQL Server databases and documentation for audits
• Developed a strategy to decrease the downtime of SAP application from 8hrs to 10 minutes
• Scheduled export and import cron jobs and monitored databases for optimal performance
• Perform Daily Monitoring of Oracle Instances, users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to Users
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL statements.
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Maintained database security by managing users roles, privileges. Implemented new security rules via roles as per the company policies.
• Replication of tables to cross platform and Creating Materialized Views.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc.,
• Configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking.
• Configured listener for external procedure calls.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.