SUMMARY

• Over Nine and Half years of extensive experience as a SQL developer and as Supporting Database Administrator working with American and Australian clients.
• Extensive experience with SQL (DDL, DML, and DCL), PL/SQL, Postgres, EnterpriseDB, MySQL and MongoDB.
• Expertise in working on Toad for oracle, SQL Developer, PgAdmin, Postgres Enterprise Manager, Oracle Enterprise Manager.
• Strong knowledge in all kinds of Database Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• Involved in Database upgrades by applying patches on the database and rolling back the patches if required on the database during integration testing, system testing and production environments.
• In - depth knowledge of PL/SQL with the experience in creating tables, views, sequences, triggers, packages, functions, materialized views etc.
• Strong knowledge in DDL, DCL, TCL and DML statements, RDBMS and data dictionaries
• Experience in writing Packages, Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Good understanding of Normalization and De-Normalization techniques.
• Knowledge in Oracle supplied packages like DBMS JOB, DBMS OUTPUT etc.
• Experience in data loading using Export and Import utilities such as UTL FILE and SQL loader.
• Management of schemas, objects & partitioning the tables & indexes, users and privileges monitoring.
• Knowledge in planning and implementing Database Security by creating users and assigning Roles.
• Performed Logical (EXP/IMP) and Data pump for taking Backup of Database Objects.
• Extensive Experience withCold Backups and Hot Backups.
• Experience in RMAN Configuration and taking Backups using catalog database.
• Performed database cloning through RMAN/physical backup from production to development & test environment.
• Tuning of applications for long running queries using TKPROF, EXPLAIN PLAN and AUTO TRACE.
• Experience in DATAGUARD(Create physical Standby) and ASM configuration for the oracle database
• Experience in RAC configuration and maintenance of RAC environments.
• Experience in ORACLE GOLDEN GATE configurations.
• Experience in Creating DBLINKS between Oracle to Oracle and Oracle to Sybase for accessing the data and User Maintained Tables(UMT).
• Experience in generating AWR, ASH and ADDM reports and analyzing the reports and suggesting the changes for better performance.
• Modified, maintained and developed the SQL codes to develop new enhancements.
• Knowledge in writing and tuning Complex Queries and familiar with Unix commands.
• Performance tuning of SQL queries used in extracting data from different source systems as well as in transformation of data using SQL and PL, SQL code.
• Implemented production database in all phases of SDLC and 24 X 7 production database on call support.
• Very familiar with Waterfall and Agile methodologies for System development and implementation.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Able to work in any kind of Environment, Self-motivated and quick learner.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, Sybase, PostgreSQL, MySQL, EnterpriseDB, MongoDB

Operating Systems: Windows Server 2008/2003/2000 , Windows Vista, Windows XP, Windows 7.0, Solaris, Linux (Red Hat), UNIX, Debian, Ubuntu

Tools: TOAD, Oracle SQL Developer, Oracle Enterprise Manager, SQL Loader, Oracle Data Modeler, Oracle Designer, Query Analyzer, Visual Studio, Putty, MS Office for Windows, Tortoise SVN,SOAP UI, Microsoft SharePoint server, PgAdmin, Postgres Enterprise Manager, Commvault, SchemaSpy,MySQL WorkBench

Languages: SQL, PL/SQL, UNIX, Perl

PROFESSIONAL EXPERIENCE

Confidential, OKC, OK

Sr.Database Administrator

Responsibilities:

• Involved in Postgres database environment setup for SRS, EHS, ER, Atlassian, Cloudera Hadoop JON and PEM.
• Involved in defining controlled user access environment by creating various Roles to different groups.
• Involved in taking backups and performing restores using Simpana Software provided by Commvault.
• Involved in Production Deployment of the scripts.
• Worked in creation of Partitioned Tables.
• Performed Pre-Migration and Post-Migration activities during the Postgres database upgrade.
• Involved in Configuring backups and testing restores using Simpana software of Commvault for Postgres and MySQL.
• Involved in configuring Postgres and MySQL database users to get authenticated with Unix LDAP and Windows Active Directory as part of security requirement.
• Supported the different versions and different types of postgres and MySQL databases.
• Postgres databases are of type Open Source, EDB, and RedHat. MySQL databases are of type Community Edition, MariaDB and Oracle Enterprise version.
• Involved in configuring ODBC from Postgres to Oracle databases using generic ODBC drivers provided by Postgres and Unix using Heterogeneous Services provide by Oracle.
• Involved in providing defined privileges to the roles and assigning the roles to users.
• Involved in taking dumps during upgrades of Postgres databases from one major version to another major using pgdump/pgdumpall.
• Supported 200 application users those use the databases by installing and maintaining Development, QA and Production databases.
• Involved in tuning of the application using EXPLAIN and EXPLAIN ANALYZE utilities.
• Involved in maintaining physical standby database which is used for generating historical reports.
• Configuring development environments by cloning production environment.
• Involved in automation of the day to day tasks by writing Unix Scripts and PL/SQL scripts.
• Involved in configuring the PEM(Postgres Enterprise Manager),monitoring the databases using the PEM, and configuring alerts using PEM.
• Involved in testing QRadar and Nessus security scans for Postgres databases.
• Experienced in supporting Linux Environment.
• Provided inputs on increasing the Performance of the database to support huge amount of data.
• Involved in Tuning the production database for handling the large amounts of data.
• Configured PgAdmin Suite for postgres and used PEM(Postgres Enterprise Manager) for monitoring the database and OS level parameters.
• Configured replication suite of environment to support active stand by database.
• Involved in configuration and maintenance of MySQL database environments.
• Involved in configuration and maintenance of MongoDB database environment for POC.

Environment: SQL, PL/SQL, Oracle 10g, Oracle 11g, Oracle12c, SQL Developer, PgAdmin, Toad, MS Office, Linux, JIRA, Stash, Bamboo, Confluence, GIT, Simpana(Commvault), Postgres Enterprise Manager, QRadar, Nessus, MySQL WorkBench, Oracle Enterprise Manager, SchemaSpy

Confidential, Carmel, IN

Sr.Database Administrator

Responsibilities:

• Involved in migrating the production database from oracle10g to oracle11g.
• Involved in defining controlled user access environment by creating various Roles to different groups.
• Involved in taking backups using RMAN configuration and catalog database.
• Involved in Production Deployment of the scripts.
• Worked in creation of Partitioned Tables and Indexes
• Performed Pre-Migration and Post-Migration activities during the oracle database upgrade.
• Involved in providing defined privileges to the roles and assigning the roles to users.
• Involved in taking dumps during migrating the oracle database from 10g to 11g using EXPDP and IMPDP.
• Supported 50 members team by installing and maintaining Development, QA and Production databases.
• Involved in tuning of the application using SQLTRACE, TKPROF and EXPLAIN PLAN utilities.
• Involved in maintaining physical standby database which is used for generating historical reports.
• Configuring development environments by cloning production environment.
• Involved in automation of the day to day tasks by writing Unix Scripts and Dynamic PL/SQL scripts.
• Involved in configuring the OEM Grid control and monitoring the databases using the OEM console.
• Experienced in supporting Linux Environment.
• Provided inputs on increasing the Performance of the database to support huge amount of data.
• Involved in Tuning the production database for handling the large amounts of data.
• Configured Toad DBA Suite for oracle and used Toad SPOTLIGHT for monitoring the database and OS level parameters.
• Configured DATA GUARD (Create physical Standby) active stand by database.
• Involved in configuration and maintenance of ORACLE RAC databases.
• Involved in configuration and maintenance of ORACLE GOLDEN GATE configuration.

Environment: SQL, PL/SQL, Oracle 10g,Oracle 11g, SQL Developer, Toad, MS Office, Linux, JIRA, SVN, GIT.

Confidential, Miami, FL

Sr. PL/SQL Developer/Sr.DBA

Responsibilities:

• Worked on PL/SQL procedures, functions and packages are developed to adhere to the specifications of the application.
• Created database objects and Developed and modified PL/SQL packages, functions, procedures, triggers using index, hints, Cursors, Ref-cursors.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Wrote PL/SQL code for Oracle Job Scheduling and Maintain Batch jobs.
• Involved in the creation of Partitioned Tables and Indexes
• Involved in the creation and modification of Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL Queries to implement the business requirements.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Wrote database triggers, created database links, synonyms.
• Involved developing materialized views, views, and synonyms and to access data across schemas, indexed to gain performance.
• Involved in Requirement Gathering, Design, Development, Unit Testing, Integration Testing and System Testing.
• Involved in the production release of the product.
• Leaded 4 members team and supported team in providing guidance.
• Invloved in tuning of the application using SQLTRACE, TKPROF and EXPLAIN PLAN utilities.
• Configuring development environments by cloning production environment.

Environment: SQL, PL/SQL, Oracle 10g,Oracle 11g, SQL Developer, Toad, MS Office, Linux, VSS.

Confidential, Austin, TX

Sr. PL/SQL Developer/Sr.DBA

Responsibilities:

• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Created composite SQL script using Dynamic SQL, Analytical function.
• Created database objects and Developed and modified PL/SQL packages, functions, procedures, triggers using index, hints, Cursors, Ref-cursors.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Wrote PL/SQL code for Oracle Job Scheduling and Maintain Batch jobs.
• Involved in the creation of Partitioned Tables and Indexes
• Involved in the creation and modification of Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL Queries to implement the business requirements.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Wrote database triggers, created database links, synonyms.
• Involved developing materialized views, views, and synonyms and to access data across schemas, indexed to gain performance.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling
• Involved in Requirement Gathering, Design, Development, Unit Testing, Integration Testing and System Testing.
• Involved in the production release of the product.
• Involved in 24 x 7 production support for any hot fix requirements.
• Leaded 25 members team and supported team in providing guidance.
• Onsite and Off-Shore co-ordination.

Environment: SQL, PL/SQL, Postgre SQL,Oracle 10g,Oracle 11g, SQL Developer, Toad, MS Office, Linux, Ubuntu, JIRA, SVN, SchemaSpy.

Confidential, Austin, TX

Sr. PL/SQL Developer/Sr.DBA

Responsibilities:

• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Responsibilities include the administrative tasks like backup, security provisioning and database refresh.
• Creating User maintained tables (UMT),Database links for connecting databases
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Optimized and modified the triggers, complex stored functions, packages, procedures etc.
• Writing scripts for tables, views and index creation.
• Developed programming units to load data from flat files into the interface tables.
• Created PL/SQL functions to facilitate business functions and calculations
• Monitoring the query performance using explain plans.
• Made use of DML triggers for updating sequences.
• Rebuild the indexes at regular intervals for better performance.
• Creation of Users, Roles & Privilege and Constraints.
• PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Data import and export using SQL Developer.
• Involved in support and troubleshooting of Database.
• Involved in Requirement Gathering, Design, Development, Unit Testing, Integration Testing and System Testing.
• Involved in mapping functional requirements to Technical design documentation.
• Developed PL/SQL procedures using dynamic SQL.
• Leaded 25 members team and supported team in providing guidance.

Environment: SQL, PL/SQL, Postgre SQL,Oracle 10g,Oracle 11g, SQL Developer, Toad, MS Office, Linux, Debian, JIRA, SVN.

Confidential

Sr. PL/SQL Developer/DBA

Responsibilities:

• Extensively involved in requirements gathering and data gathering to support developers in handling the design specification
• Involved in designing and coding of functional specifications for the data model changes.
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Created database links to access data from remote databases.
• Developed PL/SQL scripts to validate and load data into interface tables
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, UNIX, Toad, Sybase and Solaris.

Confidential

Sr. PL/SQL Developer/DBA

Responsibilities:

• Worked as a SQL developer to support business applications using Oracle SQL and PL/SQL.
• Actively involved in different stages of life cycle
• Analyzed and debugged jobs and procedures
• Created Triggers to enforce data and referential integrity.
• Developed Packages, Stored Procedures, functions and Triggers based upon the business logics.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Built and maintained SQL scripts, indexes and queries for data analysis and extraction.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed PL/SQL procedures using dynamic SQL.

Environment: Oracle9i, PL/SQL, SQL Developer, SQL*Plus, Linux.

Confidential

Sr. PL/SQL Developer/DBA

Responsibilities:

• Worked as a SQL developer to support business applications using Oracle SQL and PL/SQL.
• Actively involved in different stages of life cycle
• Analyzed and debugged jobs and procedures
• Created Triggers to enforce data and referential integrity.
• Developed Packages, Stored Procedures, functions and Triggers based upon the business logics.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Built and maintained SQL scripts, indexes and queries for data analysis and extraction.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed PL/SQL procedures using dynamic SQL.

Environment: Oracle9i, PL/SQL, SQL Developer, SQL*Plus, Linux.

Confidential

Sr. PL/SQL Developer/DBA

Responsibilities:

• Extensively involved in requirements gathering and data gathering to handle the design specifications.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to implement the functionality for different modules.
• Worked with users and application developers to identify business needs and provide solutions.
• Created Database Objects, such as Tables, Indexes, Views, and Constraints.
• Enforced database integrity using primary keys and foreign keys.
• Tuned pre-existing PL/ SQL programs for better performance.
• Implemented data validations using Database Triggers.
• Performed SQL tuning using Explain Plan. Provided support in the implementation of the project.
• Using PL/SQL Dynamic procedures during Package creation.
• Ownership was taken for the Production Deployment.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, SQL*Loader, UNIX, Toad, Sybase and Solaris.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Extensively involved in requirements gathering and data gathering to handle the design specifications.
• Involved in designing and coding of functional specifications for the data model changes.
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Created database links to access data from remote databases.
• Developed PL/SQL scripts to validate and load data into interface tables
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Involved in Production Deployment activity.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Unix, Toad, Sybase and Solaris.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Extensively involved in requirements gathering and data gathering to handle the design specifications.
• Involved in designing and coding of functional specifications for the data model changes.
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Created database links to access data from remote databases.
• Developed PL/SQL scripts to validate and load data into interface tables
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Involved in Production Deployment activity.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, UNIX, Toad, Sybase and Solaris.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Extensively involved in requirements gathering and data gathering to document the design specification.
• Involved in designing and coding of functional specifications for the data model changes.
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Created database links to access data from remote databases.
• Developed PL/SQL scripts to validate and load data into interface tables
• Involved in creating Functional and Project Specification documents.
• PL/SQL Development and Implementation.
• Involved in Production Deployment activity.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, UNIX, Toad, Sybase and Solaris.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in coding of functional specifications for the data model changes.
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Created database links to access data from remote databases.
• Developed PL/SQL scripts to validate and load data into interface tables
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Involved in Production Deployment activity.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, UNIX, Toad, Sybase and Solaris.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in coding of functional specifications for the data model changes.
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Created database links to access data from remote databases.
• Developed PL/SQL scripts to validate and load data into interface tables
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Involved in Production Deployment activity.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, UNIX, Toad, Sybase and Solaris.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in coding of functional specifications for the data model changes.
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Created database links to access data from remote databases.
• Developed PL/SQL scripts to validate and load data into interface tables
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Involved in Production Deployment activity.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, UNIX, Toad, Sybase and Solaris.