SUMMARY:

• Oracle DBA/Developer with over 8 years’ experience maintaining Oracle Database running on UNIX/LINUX (Sun Solaris, HP - UX, AIX, and RedHat Linux) and Windows and MongoDB (NOSQL).
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on Database administration for Oracle 8i, 9i, 10g, 11g and 12c with 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 11gRAC and standby database for High Availability and Disaster Recovery purpose.
• Working as a DBA using Oracle Experience with multiple master replication of remote databases.
• Experience in managing Oracle databases running on MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Clusterware Administration, Configuration and Patching.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Streams, GoldenGate Replication.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) & Cloud control for database monitoring/performance tuning/diagnostics.
• 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 8i to 9i, 9i to 10g & 11g, 10g to 11g.
• Experience on DB2 DBA and Sybase.
• Experience on Cognos tool and BOA.
• Extensive knowledge and experience on managing very large Data Warehouse databases.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Communicated with stakeholders to define business strategy to create centralized reporting capability for analytical and ad hoc reporting; wrote requirements specification documents and designed report mockups using cognos.
• Created metadata models, used data extracted from multiple DBs, and created joins and cardinality; assisted in designing DMR models; deployed packages; created filters, calculations, conditions, and layouts; developed imports/ exports to deploy reports and implemented security/access management using cognos.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Worked on Automation and Task Scheduling in different activities using differnet tools.
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Experience on MongoDB.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience on Virtual Platforms.

TECHNICAL SKILLS:

RDBMS: Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle 8i, Oracle 7.3, SQL Server, MySQL.

Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT, 2000/2003/2005.

Scripting Languages: T-SQL, Perl Script, Shell Scripting

High Availability, Tuning& Monitoring Products: Oracle 10g RAC, Oracle 11g RACTools & Utilities: ASM, Data Guard, Grid Control (OEM),Cloud control(OEM), Tkprof, Statspack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump (expdp/impdp), SQL Loader,cognos.

ETL & Reporting Tools: Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS

Backup Tools: Veritas NetBackup, NetApp, HP OmniBack, TSM, EMC

Programming Languages: C, C++, Asp.Net, XML, HTML, DHTML, CSS, Java

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Oracle DBA / Developer

Responsibilities:

• 24x7 Production database and applications support.
• Installed, configured, and maintained Oracle 10g and 11gR2, and 12c.
• Upgraded databases from Oracle 11g to 12C.
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Configured 11g RAC on ODA Oracle Database Appliance.
• Worked on configuring Oracle 11g two node RAC database on ODA Oracle Database Appliance.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Applied CPU patches.
• Worked on data analysis and database management, maintenance, and enhancement of the databases.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Experience designing data dictionaries, physical and logical database models.
• As a part of development designed physical databases and its schema.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Designed and Implemented DBaas in private and public.
• Converted and Migrated SQL server to MS AZURE.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012, 2014, 2016.
• Understanding Cassandra databases, NOSQL Databases, including query/troubleshooting/backup procedures.
• Experience in Information Technology in ODI 10g &11g (Oracle Data Integrator).
• Worked on technologies like Oracle, Oracle Data Integrator.
• Have experience in data Extraction, Loading and Transformation in data ware house environment.
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Experience maintaining business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).
• Developed Tables, Views, indexes for databases.
• Experienced in performing Point-in-Time Recovery.
• Performed Capacity Planning and Bench Marking.
• Load and Transform data using SQL*Loader and External Tables.
• Logical and Physical Database Design.
• Implemented AWS solutions using EC2, S3,RDS, EBS and Elastic Load Balancer.
• Worked on Migration of Data from SQL Server, Oracle to Cloud using AWS.
• Worked on Migration of MS SQL SERVER to AZURE.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), OEM (cloud Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

Confidential, Miami, FL

Oracle DBA / Developer

Responsibilities:

• Installed, configured, and maintained Oracle 11gR2.
• Upgraded databases to Oracle 11g and 12c.
• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Responsible for installing, upgrading, patching and configuring the Oracle environment.
• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the users.
• Partitioning and re-organization of table and indexes.
• Closing of 1000+ server data center in order to meet hosting requirements while cutting costs.
• Challenges: Zero-downtime requirement meant completing massive migration over Thanksgiving weekend.
• Role: Coordinated migration of about 100 application, web, and database servers with Data Migration Specialist, Application, and Support teams.
• Results: Reduced risk by migrating to highly resilient facilities with low natural and man-made risk exposure.
• Oracle Data identity and access management to breakthrough scalability.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Experience maintaining business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).
• Developed Tables, Views, indexes for databases.
• Experience designing data dictionaries, physical and logical database models.
• As a part of development designed physical databases and its schema.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012, 2014, 2016.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Used Data pump to take the logical backups of databases.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012, 2014, 2016.
• Maintaining the servers - applying patches and service Packs.
• Designing and supporting high availability SQL Server solutions that include Log shipping, Mirroring & Replication.
• Worked SSIS, SSRS, SSAS to generate reports and integration.
• Installing and Configuring MDM giving roles to it.
• Experience Using Cassandra increases the scalability and performance of the databases.
• Involved in Capacity planning, Data modeling, Hardware designing and initial configuration of Apache and DataStax Cassandra clusters in 2-multi data center configuration.
• Worked on Performance turning and Cassandra setup standardization process.
• Worked On Backup and Restore on MS SQL SERVER.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012, 2014, 2016.
• Worked on Performance turning and Cassandra setup standardization process.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete system Development LifeCycle.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.
• Worked on data analysis part of development team.
• Worked on maintenance of database and its enhancements.
• Designed and developed Oracle forms & reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Environment: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), OEM (cloud Control), RMAN, Explain Plan, Data Pump, SQL*Loader, AWR, ADDM.

Confidential, Cleveland, Ohio

Oracle DBA / Developer

Responsibilities:

• Provided 24X7 support for all the production and development databases.
• Extensive working knowledge of AD utilities such as adadmin, adpatch, adctrl, adlicmgr, adrelink and admerge.
• Cloned/Refreshed Oracle Databases and Oracle Applications.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012, 2014, 2016.
• Used T-SQL to create stored procedures, Triggers, views.
• Designed SSIS Packages used for ETL operations.
• Contributed to data warehouse project using SSAS.
• Set up SSRS in scale-out deployment and designed reports.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Experience maintaining business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).
• Developed Tables, Views, indexes for databases.
• Experience designing data dictionaries, physical and logical database models.
• As a part of development designed physical databases and its schema.
• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Worked on Exception handling.
• Worked on Automation and Task Scheduling in different activities using differnet tools.
• Task scheduling automation for backups and restore.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Good Understanding about ODI Architecture.
• Worked on data center migration.
• Closing of 100+ server data center in order to meet hosting requirements while cutting costs.
• Challenges: Zero-downtime requirement meant completing massive migration over Thanksgiving weekend.
• Role: Coordinated migration of about 100 application, web, and database servers with Data Migration Specialist, Application, and Support teams.
• Managing/administrating Exalogic using OEM and managing Exalogic using CLI/Graphical user interfaces.
• Experience in Information Technology in ODI 10g &11g (Oracle Data Integrator).
• Worked on technologies like Oracle, Oracle Data Integrator.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012, 2014, 2016.
• Maintaining the servers - applying patches and service Packs.
• Designing and supporting high availability SQL Server solutions that include Log shipping, Mirroring & Replication.
• Worked On Backup and Restore on MS SQL SERVER.
• Peformed Always On and Disaster recovery MS SQL SERVER.
• Tuned databases and application queries, performed server access and login management, and performed database backups and restores.
• Created metadata models, used data extracted from multiple DBs, and created joins and cardinality; assisted in designing DMR models; deployed packages; created filters, calculations, conditions, and layouts; developed imports/ exports to deploy reports and implemented security/access management using cognos.
• Worked on Oracle forms and Reports.
• Worked on data analysis part of development team to generate reports and check statuses.
• Worked on maintenance of database and its enhancements.
• As a part of database management team.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved in Logical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Provided user training and production support.

Environment: oracle 11g/Oracle 12c, REDHAT LINUX, ASM,OEM (Grid Control), OEM (cloud Control),IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, AWR, ADDM

Confidential, Nashville, TN

Oracle DBA / Developer

Responsibilities:

• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Total understanding of SDLC Process.
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Performance tuning of databases.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Install, upgrade and maintain Oracle 10g on Sun Solaris and Windows 2003.
• Worked on Oracle Forms and Reports.
• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008, 2008R2/2012, 2014, 2016.
• Used T-SQL to create stored procedures, Triggers, views.
• Designed SSIS Packages used for ETL operations.
• Experience designing data dictionaries, physical and logical database models.
• As a part of development designed physical databases and its schema.
• Experience maintaining business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).
• Developed Tables, Views, indexes for databases.
• Contributed to data warehouse project using SSAS.
• Set up SSRS in scale-out deployment and designed reports.
• Implementing Database Security, Management of role-based security.
• Good Understanding about ODI Architecture.
• Worked on data analysis part of development team to generate reports and check statuses.
• Worked on maintenance of database and its enhancements.
• As a part of database management team.
• Experience in Information Technology in ODI 10g &11g (Oracle Data Integrator).
• Worked on technologies like Oracle, Oracle Data Integrator.
• Periodic data refresh from production to testing environments, Re-organizing database structures etc.
• Scheduling the databases backup using Crontab.
• Managed and Implemented SCM improvements using BSA IT.
• Manage source code effectively using SCM best practices, such as branching, labeling, configuration control.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data-Guard with maximum availability, protection and performance configurations and worked with Data-Guard Fail over and Switch over cases at the times of up-gradation and migration.
• Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM

Confidential

Oracle DBA

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Worked on Performance tuning of databases.
• Experience designing data dictionaries, physical and logical database models.
• Instance cloning done to create test and training environments.
• Experience maintaining business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).
• Developed Tables, Views, indexes for databases.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• PL/SQL TESTING.
• Good Understanding about ODI Architecture.
• Experience in Information Technology in ODI 10g &11g (Oracle Data Integrator).
• Worked on technologies like Oracle, Oracle Data Integrator.
• WORKED ON SQL Tuning, Data Conversion, Data dictionary views.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, WINDOWS,RMAN, Explain Plan, Data Pump, EXP/IMP