OBJECTIVE

• Extremely motivated, enthusiastic, & result - oriented IT / Database Professional seeking a challenging and creative opportunity in a professional & competitive environment where my practical knowledge and professional experience can be highly used to enhance the efficiency and productivity while allowing growth in my skills.

SUMMARY

• Over 8+ years of experience as Oracle, Sql Server,DB2 Developer/DBA, providing 24x7 support of development and production 10g/11g/12c,SQLServer 2008,2012,2014 databases on LINUX/AIX/HPUX and Windows environments with Confidential, Confidential, Confidential, Confidential & Confidential in North America with multi Vendors.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g/11g/12c RAC environment. Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle 9i/10g/11g/12c, OMWB tool.
• Excellent experience in Oracle database installations 9i, 10g and 11g in Linux, HP-UX, SUN Solaris, Windows environment with hands-on experience in upgrading the Oracle databases (10gR1 to 10gR2, 9i to 10gR1, 10gR2 to 11g).
• Extensive experience in performance tuning of database, memory & I/O using tools such as AWR, ADDM, STATSPACK and analyzing queries using EXPLAIN PLAN, SQL-TRACE, TKPROF.
• Extensive experience in performing backups and tested crash recoveries using conventional hot, cold backups and RMAN. Hands on experience of daily monitoring of Oracle instances and maintenance of databases using Oracle Enterprise Manager(OEM), Oracle GRID, ISQL*Plus, and SQL*Plus Command line scripts.
• Experienced with Data Guard, creation of physical standby and resolving the physical standby database gap. Expertised in using golden gate to support data replication in the oracle database environment.
• Experience with Data Guard, creation of physical standby and resolving the physical standby database gap.
• Proficient in SQL, PL/SQL, stored procedures, packages, triggers, forms and reports, DBMS * and UTL * packages. Experience in shell scripting for various CRON jobs to run.
• Efficient in security administration by creating and maintaining users with appropriate profiles, roles and privileges to access network resources. Management of schemas, objects & partitioning the tables & indexes.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, Veritas NetBackup. Worked on Advance replication including Synchronous and asynchronous scenarios.
• A self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges, strong listening, interpersonal and analytical skills.

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential

Responsibilities:

• Managed Oracle, SQL Server and DB2 database administration, backup and recovery, schema maintenance, performance tuning, performance monitoring, design and implementation. Responsible for Database Administration of Oracle RAC 10g/11g and non RAC databases on ASM with size of databases varying from 200GB to 40TB. building the core database engine behind MemSQL. this includes developing in-memory and on-disk data structures and algorithms, row and columnar stores, networking, query optimization, and execution.
• Transformed logical database designs into physical databases; Build and implement test, quality assurance, and production databases and environments; Coordinated strategies to move data between databases; Monitored database space requirements and adjusted for future needs
• Extensively worked on configuring OEM grid control agent on new servers, registering new databases in 11g OEM Grid Control and automated RMAN and data pump backups in 10g/11g OEM Grid Control.
• Installed Oracle cluster ware, Configuring public and private network and VIP with SRVCTL, OCR and Voting Disk of 10g/11g RAC
• Implemented high security policies for user accounts, passwords, profiles, roles and privileges across the Oracle database environments. Implementation and administration of Oracle Audit Vault, VPD, VPC and data encryption for sensitive data. Regular Security patching on oracle products and interim patching for various bug fixes on database products.
• Fulfilled DBA daily activities including user management, space management, monitoring etc. Experienced in using 11g features like Database Replay, Partitioning, LogMiner, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security. Oracle 11i upgrade to R12 on Linux and AIX. SAN and NAS management.
• Managed Database backup using RMAN with TSM and/or Netbackup,9i, 10g,11g RAC, OEM Grid Control, ASM, UNIX/LINUX Shell Script. Created Golden Gateextracts process, extract pump, fan out pump, and replicate. Performed data replication, transformation and delivery of database transaction usingGolden Gatereplication tool. Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Managed and Implemented high availability options i.e. advance replication to ensure prompt response and support multiple users across the globe by maintaining multiple master sites and kept them tied up with Asynchronous replication.
• Configuring OEM grid control agent on new servers, registering new databases in 11g OEM Grid Control and automated RMAN and data pump backups in 10g/11g OEM Grid Control. Migrating and upgrading the Oracle 11g database to Oracle 12g and incorporating the changes in the database design.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server. Managed different Extraction Transformation and Loading (ETL) processes using tools like SSIS, DTS, BCP between different homogeneous/heterogeneous systems and SQLServer and implemented Incremental load in SSIS packages.
• Installed, configured and maintained Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases. Assisted in integration of Exadata application into current IT actionable events and Solutions. Managed Physical & Logical standby databases in RAC and non-RAC environments
• Extensively used AWR, ADDM for database performance statistics. SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
• Managed different Extraction Transformation and Loading (ETL) processes using tools like SSIS, DTS, BCP between different homogeneous/heterogeneous systems and SQLServer and implemented Incremental load in SSIS packages.
• Experienced in providing trend analysis to the service management team to enable them to make informed decisions regarding resource management.
• Extensively implemented Data pump, conventional Export/Import (Oracle10g, 11g and 12c) for migration and logical backup of database. Performed Migration and Upgrade of databases to 12c and 11g.

Database Administrator

Confidential

Responsibilities:

• Worked as a DBA, managing around 200 databases with heterogeneous environment of Oracle 9i, 10G,IBM DB2 (v8.1.7.445) and SQL Server 2005,2008. Worked on high scale Vendors Enterprise Management System.
• Managed Oracle RAC 10g/11g and non RAC databases on ASM with size of databases varying from 200GB to 15TB. Implemented 11gR2 Data Guard using RMAN duplicate.
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.
• Used Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• Wrote triggers and stored procedures to integrate 3rd party applications into in-house applications 1such as project management systems with a minimum of development time.
• Managed database architecture and program design, including survey systems, report developers, OLAP cubes, and interfaces with clients’ CRM software.
• Evaluated, designed, coded, tested and implemented a customized DBA Manager Application to automate many of the database administration duties performed within a client's Oracle environment.
• Set up SQLServer configuration settings and implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Involved in trouble shooting and fine-tuning of databases for its performance and concurrencyMaintained transactional replication on production SQLServers and maintaining the database consistency with DBCC Confidential regular intervals.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, using HINTS, EXPLAIN PLAN and STATSPACK etc
• Involved in writing thousand of lines of code in SQL, PL/SQL and transact-SQL to implement business rules, for data extraction, transformation and loading, and for daily database maintenance.
• Rebuilding of Indexes and managing the table partitions for better performance, maintenance of OracleDatabase. Establish Backup policy using RMAN and VNB (Veritas Net Backup). Also managed Backup, Restore using Data Pump, Traditional Export and Import Utilities
• Designed server-to-server replication algorithms that kept multiple large databases in sync across a LAN, and server switchover software that provided database fault tolerance
• Tuned database and application for better response times, space management, involved in implementing and managing Oracle Standby Databases.
• Served as a senior Oracle database administrator performing all duties to maintain the Oracle data repository. Responsibilities included Oracle instance tuning, Oracle SQL tuning and Oracle application tuning. Worked with developers in complex systems development and mentored developers in using PL/SQL, VB for developing Oracle application systems.
• Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL and SQL*Loader; and cron jobs calling Unix scripts to download and manipulate files.

Confidential

Responsibilities:

• Performed the requirements analysis, process and data flow analysis, functional specifications, data modeling, physical database design, forms design and development, data conversion, performance analysis and tuning and general DBA functions.
• Provided management with tools to optimize analysis of business information to provide an edge on making sound decisions.
• Evaluated, designed, coded, tested and implemented a customized DBA Manager Application to automate many of the database administration duties performed within a client's Oracle environment.