SUMMARY:

• Around10years of experience as Database administrator (DBA) in designing, coding, testing and supporting next - generation database solutions in Oracle enterprise and IBM DB2 environments. Proficient in an assortment of technologies, including Oracle (10g, 11g, 12c), DB2 LUW (10.1,10.5,11.1), Access, JDBC, Visio, Windows, Linux and Unix. DBA skills include
• Administering IBM DB2 LUW and ORACLE production, test, and development environments and analyze production performance issues and data defects.
• Install, configure and manage IBM DB2 and ORACLE in high available clustered environment.
• Analyze/Provide/Modify data models using Erwin Data Modeler.
• Expertized in configuring MQ replication to replicate database between two database servers.
• Working closely wif client, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues halping to transform business requirements into environment specific databases
• Knowledge on DB2 Purescale and PDTX.
• Control M Workload Automation Setup wif required set of rules. Scheduling and Monitoring Batch Jobs using Control M.
• Providing support to client and developers regarding SQL queries, applications errors, database errors.
• Expertized in performing regular performance tests and disaster recovery tests.
• Generating reports using LogMiner and analyzing
• Perform DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence) and Data Migrations.
• Cleansing/Masking Production data using Pentaho transformations.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk me/O, Sizing of tables and indexes.
• Knowledge on DB2 HADRand resolving SPLIT BRAIN Scenarios.
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving.
• Run reports periodically to check the database health.
• Installed oracle database server on AIX, WINDOWS NT, LINUX and migration of oracle server from 9i to 10g and 10g to 11g applied oracle patches.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, SQL Developer, TOAD and IBM Data Studio.
• Installation and Configuration of Oracle Grid Control.
• Worked on space management (tablespace, rollback segment), monitoring (alert log, memory, disk me/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Installation and configuring Pentaho ETL Tool in UNIX and Windows Environments.
• Involved in performance tuning and database reorganizations. Performed SAN analysis and provided recommendations.
• Maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM,CRS Cluster.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN Backup. Incomplete recovery and disaster recovery using Standby database or Data Guard by implementing RMAN backup
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Having hands on experience wif GoldenGate10.4.
• Performance Tuning me.e. tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms
• Experience wif SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Good co-ordination and communication wif system administrators, business data analysts and development teams

TECHNICAL SKILLS:

Operating Systems: IBM-AIX, Red Hat Linux,Windows NT/2000/2003

Languages: SQL, PL/SQL, C, C++, Batch, Bash &Kornshell Scripting

DBA Tools: RMAN, Oracle Import/Export, Data Pump, SQL*Loader, Oracle Enterprise Manager cloud control 12c, Automatic Storage Management, ASMM, db2look,db2 export/import,db2pd

Monitoring Tools: TOAD, OEM, 10g Grid Control, ASH,ADDM,OPTIM Performance Manager, Foglight

Tuning Tools: TKPROF,Explain Plan,Statspack,AWR,ADDM,db2advis

RDBMS Tech: Oracle 9i, 10g,11g, 9i/10g RAC, IBM 9.7,10.1,10.5,IBM 10.5 purescale, IBM 10.5 PureData System for Transactions PDTX .

Data Modeling Tools: Erwin r7.3 and Erwin r9.64, SQL Datamodeler.

Backup Tools: OLTP.RMAN, Oracle Data Guard (failover, standby, disaster recovery), Flashback Database, db2 backup redirect recovery

ETL Tools: Pentaho 4.2.1, Informatica 9.6.1

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, Connecticut

Database Administrator/Data modeler

RESPONSIBILITIES:

• Administering IBM DB2 production, test, and development environment on IBM-AIX, and Linux as a team lead.
• Working closely wif client, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues halping to transform business requirements into environment specific databases
• Migration of databases from IBM DB2 10.5 to 11.1
• Documenting database changes and updating data models according to the changes applicable to the application.
• Analyzing the data flow for SNAP, TANF and MA applications.
• Played a key role in preparing and providing deliverables to the client on Database management process wif respective data models generated using ERwin data modeler.
• Managing Database Build schedules and Refresh schedules to Non-Prod Environments.
• Configuring MQ Replication to replicate data between two database servers.
• Managing Backups and Recovery of DB2databases.
• Configuring and cloning data related SNAP, TANF and MAapplicationcases wif in the databases.
• Providing guidance in integration of MA applications between Access health for Connecticut (ahCT) and Integrated Eligibility system (ImpaCT).
• Performance Tuning of Database by scheduling optimization and guiding Team in tuning SQL queries based on cost of the queries.
• Analyzing Bottle necks of database and resolving based onSNAPSHOTfindings.
• Analyzing SQLs by generating explain plans and executing db2advis utility.
• Generating DDLs for DB2databases using db2look utility.
• Involved in designing the database, identification of the objects and creating SNAP, TANF and MA application tables.
• Developed several intricate procedures and functions to accommodate data manipulation.
• Created Views, Synonyms, Sequences and Indexes.
• Run reports periodically to check the database health.
• Monitor Database using FOGLIGHT utility.
• Migrating Data between specific environments.
• Developed PL/SQL scripts wifexception handling.
• Developing Conversion load transformations using Informatica ETL tool.

Confidential,Hartford, Connecticut

Database Administrator/Data modeler

Environment: IBM Db2 10.1, 10.5IBM-AIX, Linux, Windows Server 2003,Toad, PL/SQL Developer8.0, Shell Scripting, IBM Data Studio.

RESPONSIBILITIES:

• Documenting database changes and updating data models according to the changes applicable to the application.
• Played a key role in preparing and providing deliverables to the client on Database management process wif respective data models generated using ERwin data modeler.
• Managing Database Build schedules and Refresh schedules to Non-Prod Environments.
• Coordinating wif development team to make database changes.
• Performance Tuning of Database by scheduling optimization and guiding Team in tuning SQL queries based on cost of the queries.
• Upgrade database server from IBM DB2 10.1 to 10.5.
• Involved in designing the database, identification of the objects and creating tables.
• Created Tables, Views, Synonyms, Sequences and Indexes.
• Migrating Data between specific environments.
• Developed PL/SQL scripts wifexception handling.

Confidential

Database Administrator/Data modeler

Environment: Oracle 11g, IBM-AIX, Linux, Windows Server 2003,Toad, PL/SQL Developer8.0, OEM 12c, Shell Scripting, Control M, Pentaho 4.1.

RESPONSIBILITIES:

• Administering Oracle 11g/10g production, test, development environment on Windows Server 2003, IBM-AIX, and Linux as a team lead.
• Managing Database Build schedules and Refresh schedules to Non-Prod Environments.
• Worked as onshore primary contact to the customer wif a team of two DBAs in offshore.
• Implemented RMAN Duplication process to refresh the TEST and UAT Databases for implementing code patches.
• Performance Tuning of Database by scheduling optimization and guiding Team in tuning SQL queries based on cost of the queries.
• Analyzing Bottle necks of database and resolving based on ADDM and ASH findings.
• Implementing Security using Oracle Database Vault to protect application data stored in the Oracle database from being accessed by privileged database users.
• Installation and configuring Pentaho ETL Tool in UNIX and Windows Environments.
• Developing Conversion load transformations using Pentaho ETL tool.
• Masking or Cleansing Production data using Pentaho transformations before migrating data into development environments for analyzing defects and hot fixes.
• Scheduling and Monitoring Batch Jobs using Control M.
• Control M Workload Automation Setup.
• Generating reports using ERwin and maintaining the database inventory.
• Creating data models using ERwin and SQL Developer Datamodelerby reverse engineering.
• Migration of Database between platforms (Windows Server 2003 to IBM-AIX and vice versa).
• Expertise in doing impact analysis for the DDL/DML changes on the database proposed by the development team.
• User creation and enforcing security using privileges and roles.
• Automatic Advanced SQL Tuning using TOAD.
• Session Monitoring using TOAD and OEM, Checking for long running queries blocking sessions.
• Using the tools such as TKPROF, EXPLAIN PLAN and TRACE FILE to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing& capacity planning for Oracle databases.
• Export and import of database objects from one platform to another.
• Hands on experience on Supervisory Skills like maintaining schemas and partitioning tables.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, SQL Trace, Explain plans.
• Experienced wif all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for standalone instances.
• Creating tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Expertise on DDL commands like creating and dropping of users, granting and revoking permissions to users/roles as and when required.

Confidential

Database Administrator/Data modeler

Environment: Oracle 11g, IBM-AIX, Linux, Windows Server 2003,Toad, PL/SQL Developer8.0, OEM 12c, Shell Scripting, Control M, Pentaho 4.1.

RESPONSIBILITIES:

• Administering Oracle 11g/10g production, test, development environment on Windows Server 2003, IBM-AIX, and Linux as a team lead.
• Managing Database Build schedules and Refresh schedules to Non-Prod Environments.
• Worked as onshore primary contact to the customer wif a team of two DBAs in offshore.
• Implemented RMAN Duplication process to refresh the TEST and UAT Databases for implementing code patches.
• Performance Tuning of Database by scheduling optimization and guiding Team in tuning SQL queries based on cost of the queries.
• Analyzing Bottle necks of database and resolving based on ADDM and ASH findings.
• Implementing Security using Oracle Database Vault to protect application data stored in the Oracle database from being accessed by privileged database users.
• Installation and configuring Pentaho ETL Tool in UNIX and Windows Environments.
• Developing Conversion load transformations using Pentaho ETL tool.
• Masking or Cleansing Production data using Pentaho transformations before migrating data into development environments for analyzing defects and hot fixes.
• Scheduling and Monitoring Batch Jobs using Control M.
• Control M Workload Automation Setup.
• Generating reports using ERwin and maintaining the database inventory.
• Creating data models using ERwin and SQL Developer Datamodelerby reverse engineering.
• Migration of Database between platforms (Windows Server 2003 to IBM-AIX and vice versa).
• Expertise in doing impact analysis for the DDL/DML changes on the database proposed by the development team.
• User creation and enforcing security using privileges and roles.
• Automatic Advanced SQL Tuning using TOAD.
• Session Monitoring using TOAD and OEM, Checking for long running queries blocking sessions.
• Using the tools such as TKPROF, EXPLAIN PLAN and TRACE FILE to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing& capacity planning for Oracle databases.
• Export and import of database objects from one platform to another.
• Hands on experience on Supervisory Skills like maintaining schemas and partitioning tables.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, SQL Trace, Explain plans.
• Experienced wif all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for standalone instances.
• Creating tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Expertise on DDL commands like creating and dropping of users, granting and revoking permissions to users/roles as and when required.

Confidential

Oracle Database Administrator

Environment: Oracle 10g, 11g RAC, Grid Control 10gR5, ASM, RHEL 4, 5, IBM-AIX.Shell Scripting.

RESPONSIBILITIES:

• Actively participated in the installation of 10 g RAC on LINUX environment.
• Installed 10g RAC (2 Node) on RHEL 4 Server and converted/added a node to 3 Node RAC for production databases
• Administering Oracle 11g/10g production, test, development environment on RHEL, IBM-AIX.
• Skilled wif STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Using the tools such as TKPROF, EXPLAIN PLAN and TRACE FILE to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing& capacity planning for Oracle databases.
• Migration of Database from 9i to 10g and applying patches whenever required.
• Upgrade of Databases from 10g to 11g
• Experienced wif SRVCTL, OCR and Voting Disk of 10g RAC
• Developed 10 PL/SQL Packages from the scratch which are used for Extract Transform and Load purpose.
• RAC Troubleshooting.
• Worked DataPump and Extract using GoldenGate10.4.
• Implemented the Security using ORACLE Database Vault.
• Experienced wif all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Creating tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced wif Space Management and Security.
• Experienced wif precise (DB performance tuning tool).
• Experienced wif Data guard Implementation
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.

Confidential

Oracle PL/SQL Developer

Environment: RHEL, Windows, Oracle 10g, SQL, PL/SQL, UNIX Shell scripting.

RESPONSIBILITIES:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• Worked closely wif developers in Designing Schema / tuning PL*SQL/ SQL code
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Created various Database triggers using PL/SQL.
• Extensively used Explicit Cursors in stored procedures.
• Developed several intricate procedures and functions to accommodate data manipulation.
• Created Tables, Views, Synonyms, Sequences and Indexes.