We provide IT Staff Augmentation Services!

Application Migration Engineer/dba Resume

Charlotte, NC

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 & “Leading edge” project design, development, implementation and Migrations, experienced in ERP implementations of Oracle and SAP
  • 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 3 node cluster and ASM based databases.
  • 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:

Application Migration Engineer/DBA

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.
  • Developed plans for upgrades of MS-SQL Server, 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, MN

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.
  • 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 and Beast.
  • 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.
  • 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 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.
  • Daily Health Check Up of the Database using AWR, ADDM.
  • Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
  • 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.
  • 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 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.
  • Created scripts for secure banking transactions between Confidential JP Morgan, Ceridian and Bank OF Montreal

Hire Now