SUMMARY

• Over 14 years of experience in IT, of which over 13 years in Oracle 8i/9i/10g/11g/12c and 1 year in MS SQL SERVER 2000/2005
• Datastax Cassandra certification
• AWS Solution Architect certification
• 2 Year hands - on experience of AWS, Worked with ansible / jenkin / CloudFormation to automate EC2 build.
• Basic Knowledge of postrgresql.
• Currently working as Lead DBA to support one of the most critical applications.
• Currently working on NoSQL Cassandra DB, configured 44 nodes WAN prod cluster.
• Monitoring and Maintenance of 90 nodes cluster running on Datastax / open Source Apache.
• Knowledge of TimesTen (oracle in memory database).
• Currently Supporting Oracle DB on T4 / M7 SuperCluster with 10 storage cells and 4 compute nodes.
• Extensive Oracle Database Administration experience on Sun Solaris, AIX, HP-UX and Windows NT/2000.
• Strong Experience of Installing Oracle Databases and Upgrading them ( from 9i,10g,11g to 12c ( release 1 and release 2 ))
• Expert in upgrading Oracle Databases from 10g to 11g.
• Installation and Configuration of Real Application Clusters (RAC) with Automatic Storage Management (ASM).
• Experience of Installing, Configuring and Monitoring SQL Server 2000/2005 Databases.
• Extensive experience of Database design, Data modeling and Data administration
• Sound knowledge of latest DBA tools e.g. OEM, TOAD and SQL Developer
• Sound Knowledge of Replication Tools like Shareplex for Oracle and DataMirror ( CDC )
• Experience in Installing and configuring OID ( Oracle Internet Directory )
• Extensive experience of Configuring Database Replication using Shareplex
• Strong Experience of Configuring and Maintaining Physical DataGuard for 24*7 availability and disaster recovery.
• SQL Performance Tuning using tools like AWR, ADDM, ASH, Explain plans and SQL Monitor.
• Sound knowledge of RMAN and Data Pump, used latest features like RMAN Active Duplication,
• Experience in Applying Quarterly CPU/PSU Patches, Partition Maintenance, security management, auditing, general troubleshooting and configuring servers.
• Experience of configuring Replication between oracle databases using shareplex.
• Experience of configuring Replication between oracle and DB2 databases using Data Mirror (CDC).
• Extensive Experience of Performing Backup and Recovery using RMAN, Data Pump and Flashback
• Extensive experience of database administration using Oracle OEM GRID Control
• Mid Level experience of Oracle Streams and Advance Queue (AQ).
• Good Experience of writing Perl and KSH Scripts for monitoring of production databases.
• Knowledge of Data transfer between SQL Server and Oracle.
• Extensive use of DTS in SQL Server, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i/8i, Timesten DB, Cassandra, SQL Server 2000/2005,Ms-Access, Amazon Aurora with postgresql

Languages: C, C++, PL/SQL, Java, Perl, Python and KSH

RAD Tools: Visual Basic 5.0/6.0, MS Visual-InterDev 6.0

Replication Tools: Shareplex for Oracle, Datamirror,GoldenGate, AQ

Oracle GUI Tools: OEM, TOAD, DBArtisan, SQL Developer. Pgadmin

Data Modeling tools: ERWIN

Operating System: HP-UX, AIX, Sun Solaris, Red Hat Linux, Windows N.T 4.0/2000, Windows 95/98.

PROFESSIONAL EXPERIENCE

SENIOR Lead ORACLE DBA

Confidential, Orangeburg, NY

Responsibilities:

• Fresh Installation, Configuration and maintenance of Oracle 12c/11g/10g on Solaris (SPARC/X86), AIX, HP-UX and windows.
• Leading a team comprising 4 DBAs supporting one of the multi-site critical applications.
• Migrated M5000 Solaris Sparc to T4-4/M7 supercluster
• Automating EC2 builds in AWS using jenkin/ansible/Cloudformation.
• Upgrade 10g/11g RAC and Non-RAC databases to 11g/12c.
• Support Large multi-site databases which are over 5TB.
• Completed several Tech Refreshes and Data Center Migrations
• Maintenance and Monitoring of RAC and Non-RAC databases through 10g/11g/12c Grid Control (OEM), also provide 24*7 on-call support on rotation basis.
• Configured RAC with 4 nodes using Automatic Storage Management, Administration and Maintenance of RAC databases.
• Configuring and Maintaining Physical Dataguard environment for 24*7 availability and disaster recovery.
• Applying Quarterly CPU/PSU patches on RAC and Non-RAC environment,
• Reorganization and Partition Maintenance of databases every six months, Flashback configuration for easy recovery.
• Migration of 10g databases from Windows to Solaris machines, Character set conversion from to AL32UTF8
• Fixing Bad SQL plans using SQL Profile and SQL plan baseline.
• Database Cloning using RMAN Active Duplication (11g Feature).
• Performing Backup and Recovery of approximately ~4TB DB using RMAN for Oracle 10g and 11g Databases, Backing up 4TB DB to Tape
• Performance tuning of databases using various oracle tools e.g. explain plans, AWR,ADDM,ASH etc
• Writing KSH scripts to monitor databases and alert DBAs on critical events such as file system getting full, tablespace getting full, ORA- errors in alert log
• Maintenance of RMAN, Data Pump and other KSH/PERL scripts
• Supporting Unix OS Quarterly Patching, Testing Automatic Failover/Fail-back of unix nodes using VCS,
• Implementing and testing monthly Application Releases.
• Perform load testing using 11g RAT (Real Application Testing).
• Extensively used STS (SQL Tuning Sets) and SPA (SQL Performance Analyzer) to compare before maintenance and after maintenance performance.
• Installation and Configuration of OID 11g (Oracle Internet Directory) to resolve TNSNAMES across the whole enterprise.
• Setup and Maintenance of Multi-way replication between oracle databases using Shareplex for Oracle
• Installation and Configuration of Datamirror to replicate data between oracle and DB2
• Supporting Advance Queuing and Messaging Gateway Applications.
• Installation and Configuration of Timesten In-Memory database. Setup Replication of data from oracle to Timesten using Cache Groups.
• Installing and Configuring 48 nodes NoSQL cassandra DB.
• Configuring Oracle Configuration Manager ( OCM ) to upload Database Info to Metalink ( My oracle Support )
• Creating Standard jenkin jobs to release Quarterly oracle AMIs as per security Standards
• AWS automation using Ansible and AWS CLI commands.
• Backing up and Restoring Database in EC2 from EBS snapshots.
• Quartely rehydration of EC2 instances .

Environment: Oracle 11g/12c (on Solaris, AIX, HP-UX, Windows), Oracle T4/M7 Supercluster, NoSQL Cassandra, DataMirror, InmemoryTimesten DB, SharePlex, OID (oracle internet directory), AQ, Messaging Gateway,VTL Tape, AWS, Ansible/Jenkin, Amazon Aurora with Postgresql, EC2, EFS

ORACLE/SQL SERVER DBA

Confidential, Chicago IL

Responsibilities:

• Fresh Installation, Configuration and maintenance of Oracle 10g/9i/8i on Intel/Unix (HP-UX, AIX, Windows)
• Involved in cloning and patching of Oracle databases, Strong experience in Patching and Cloning of Oracle 9i and 10g Databases.
• Designed Scripts to monitor the databases and alert the DBA on events such as running out of disk space, max number of processes, free space in tablespace etc. Actively involved in Korn Shell Scripting for various cron Jobs.
• Management of data files, redo log files, control files, tablespaces, segments, extents and data blocks. monitoring and management of database users, granting/revoking of system/object privileges
• Performing Backup and Recovery using RMAN for Oracle 8i, 9i and 10g Databases
• Configuration and Maintenance of Data Guard based on SAN storage
• Creation and Management of tablespaces, tables, indexes, views, integrity constraints, synonyms, user accounts, roles and privileges, space allocation
• Experience of Implementing Hot/Cold Backup & Recovery strategies
• Creating RMAN repository and taking backup of the databases using RMAN, Monitoring and Maintenance of RMAN Backups running on Tape ( VERITAS NET BACKUP ) and verifying their integrity by performing monthly restore of tape backups on Test Databases.
• Extensively used SQL Analyze and Explain Plan on production databases
• Monthly Refresh of Development/Test Databases' Schemas from Production using Oracle Import and Export Utilities.
• Part of the 9 member On-Call Rotation Team to provide 24x7 support to 400 Oracle and SQL Server Production Databases.
• Designing Monitoring Scripts using Perl and T-SQL
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation
• Installation, tuning, maintenance and monitoring of SQL Server databases
• Upgrading of SQL Server databases from SQL 2000 to SQL 2005
• Experience of Installing SQL Server 2005 on Polyserve Matrix for High Availability.
• Created DTS packages for migration of data from SQL Server to Oracle Databases.

Environment: Oracle 8i/9i/10g running on AIX,HP-UX, Intel, HP OpenView, SQL Server 2000/2005, SQL*Loader, RMAN, SQL Query Analyzer, Glance, Perl, TOAD, DBArtisan, Control-M, Veritas Net Backup, PolyServe for SQL Server

ORACLE DBA/SQA Engineer

Confidential

Responsibilities:

• Installation and configuration of Oracle and maintenance of servers in various environments.
• Perform Black Box and White Box testing.
• Design Comprehensive Test Plan, Test Cases and execute them
• Perform software application testing and conduct technical support.
• Database and System Administration, Creation of file systems, users, Installation and Creation of databases, tuning query, rollback, disk I/O
• Create users, roles and profiles with different security levels. Grant and revoke privileges
• Provide on call support related to Oracle DBA activities
• Automating jobs using UNIX shell scripts, Crontab
• Help client sites in resolving performance issues
• Assist client sites in database design per application requirements
• Design, architecture, development, implementation and maintenance of databases
• Logical design of the database using Erwin. Translating the logical model into physical model. Accommodate user requests and perform rigorous testing using dummy data
• Participate in design strategy sessions.
• Performance Tuning and Maintenance of SQL Server Databases.
• Refreshing Test/Development SQL Server Databases from Production.

Environment: Oracle 8i, JDBC,SQL Server, PL/SQL, ODBC, Windows NT, Database Tools/Utilities, Erwin, -SQL, Query Analyzer, DTS, BCP, Enterprise Manager