PROFESSIONAL SUMMARY:

• 6 Years’ experience as an SQL and Oracle Database Administrator having hands on experience in production design and test environments. Also having experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting, Golden Gate and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g, 12c with experience within very large scale database environment.
• Hands on experience in building Internet Native Banner ERP and Self Service Banner ERP servers utilizing Oracle Weblogic OFM and Tomcat.
• Hands on experience in Database Administration and Developer for very large and complex databases in SQL Server 2016, 2014, 2012, SQL Server 2008 R2, 2008 and 2005
• Expertise in Always - On Availability Groups (AAG) and HA/DR Troubleshooting
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g with experience within very large scale database environment.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• 24*7 production database support with Support to developers & end-users.
• Also having a hands on experience with backup strategies like Hot/Cold Backup, disaster recovery, RMAN, Export/Import, Data Pump and Flashback Technologies.
• Have a good and great experience of database backups and recovery methods like PITR (point-in-time-recovery), TSPITR (Tablespace-PITR).
• Designed and implemented Backup and Recovery strategies using conventional and RMAN utilities (Full, incremental and cumulative).
• Database replication using snapshots, materialized views and advanced Replication methods.
• Activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER.
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Experience in applying security patches to the databases.
• Expertise in Performance information and monitoring/interpreting alert log and trace files.
• Experience in use of SQL diagnostic and tuning tools like autotrace to generate reports like AWR/ADDM Reports.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNS-Names, V$ and DBA views.
• Extensive knowledge on tools like Tableau, data visualization and business intelligence tool
• Created Dashboards using Tableau connected to tableau POSTGRE SQL database to create customized interface for tableau workbooks
• Have used Tableau to connect to the relational, cloud databases, spread sheets and then to generate a number of graph types
• Created data sources, created reports such as Pie charts, Bar graphs, Maps, Bullet graphs using Tableau
• Hands on experience on oracle Exadata in Assisting in installation, assembly and patching of Exadata and oracle applications

TECHNICAL SKILLS:

Platforms: Linux (Red Hart Enterprise Linux, Oracle Enterprise Linux), Sun Solaris 9, 10, AIX 5.x, Windows XP, Windows 7, HP-UX

Programming Languages: SQL, PL/SQL, Shell Scripting, C

RDMS: Oracle 11g/10g/9i, 12c

Tools: Golden Gate, EXP/IMP, EXPDP/IMPDP(DATA PUMP), RMAN, SQL Loader, SQL Developer, Toad, OEM, DBCA, DBUA

Tuning Tools: TKPROF, Statspack, SQL Trace, Explain Plan, AWR, ADDM, ASH, SQL Tuning Advisors

PROFESSIONAL EXPERIENCE:

Confidential, TX

Oracle/SQL DBA

Responsibilities:

• Responsible for monitoring 200+ SQL Server databases on production, test and development Servers
• Installation and Configuration of Microsoft SQL server 2016 on our Production environment for database access, which also provides real time operational analytics, data is always encrypted, Revamped SQL Server data tools etc.,
• Microsoft SQL SERVER MANAGEMENT STUDIO 2005, 2008R2, 2012,2014 & 2016 used for administration and maintenance of SQL server databases
• SQL Server Database Migration, Cloning, detach, attach, restores, mirror were performed with in user requirements
• Installing, maintaining, upgrading SQL Server binaries/instances/databases
• Database failovers/recoveries
• Support database structure and data changes for application, development, testing and deployment
• Supporting SQL Server mirrored databases and always On clustered environments.
• Responsible for enforcing IT policy and security requirements for database access and controls
• Experience working with support teams like web server admins, network admins, O/S admins.
• Responsible for creating maintenance plans for all the SQL Servers like backing up transactional logs, creating backup sets, maintenance cleanup jobs, used in restoring databases during database crash or fail
• Collect CPU, Memory usage, blocking query reports and troubleshoot and fix the root-cause of the CPU, Memory issues and blocking on a database/server
• Expertise in Oracle and Database Application clients like TOAD, SQL Developer and Spotlight
• Perform Database Refreshes periodically using oracle datapump export/import which could be table level, schema level, Full Database.
• Experience on Oracle Enterprise Manager Cloud Control 13c and Grid Control
• Installed & Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 10g to 11g.
• Responsible for Restoration and Recovery of databases at the time of occurrence of critical failures.
• Support departmental operations in a high-throughput production environment by proactively managing the performance, optimization, integrity, and security of institutional database and systems like SIS
• Setup, monitor, and maintain disasters recovery solutions for enterprise productions database
• Architect, manage, test, and provide support to multiple enterprise wide database system and applications
• Design, create, install, and maintain highly available and secure enterprise database instances to include database architecture, database backups creation of databases and database objects such as tables, indexes, views, triggers, ad stored procedures to support enterprise level application
• Code database description and specify identifiers of database to database management system to direct other in coding database description
• Modify database programs to increase processing performance, referred to as performance tuning
• Consult on server design coordinate changes to server applications, lead and manage successful upgrade and implementation of existing and emerging technologies in database environment
• Schedule and perform installation and upgrades of enterprise level databases and applications and maintains them in accordance with established Information technology policies and procedures
• Applications services WebLogic, Apache Tomcat, Administrations, Maintenance and operations of oracle applications /WebLogic server
• Assisted in installation, assembly and patching of Exadata and oracle applications
• MYSQL MariaDB database administration
• Managing Azure Services, working with SSIS & SSRS packages

Confidential, Charlotte, NC

Oracle/SQL DBA

Responsibilities:

• Hands on with Microsoft System Center Operations Manager (SCOM)
• Experience working with Catalogic, TDP & TSM
• Experience with Business Objects R4 systems administration
• Experience with EMC SAN architectures a plus * Experience administering email systems and Unix Sendmail
• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Activities include in writing, testing and maintaining T-SQL, stored procedures and SSIS packages
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services(SSAS) and Power Shell
• Experience in Maintaining, writing and testing windows scripts
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Review the alert log in 12c
• Hands on database administration with 11g and 12c, upgraded production databases from 11g to 12c
• Determine if there is block level corruption. Report new blocks corrupted and corrupted blocks remaining from the previous report
• Verify the status of last backup. Report new backup corruption and previous unmitigated backup corruption
• Configured High availability and setup custom monitoring through Heart beat tables using Golden Gate.
• Upgraded golden gate from 11.1 version to 11.2 version on 11gR2.
• Worked with application team for setting up conflict handlers in Golden gate.
• Used BATCHSQL, RANGE functions to improve throughput in Golden gate REPLICATES.
• Troubleshoot slow running EXTRACTS, REPLICATES and tuning.
• Performed Oracle 11g RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging
• Involved in implementing 11g RAC with ASM disk on Linux servers.
• Migrated database Schemas from Single instance to RAC.
• Duplicated RAC Databases in non-production environment through RMAN.
• Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
• Installed Oracle 10g/11g/12c stand-alone and RAC systems in HA environment in different O.S platforms (AIX, Linux, Solaris, RHEL and VMware).
• SQL Profiling, SQL Plan Baselines, SQL Trace, ADDM, AWR, ASH and Explain Plan tools to diagnose performance issues.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Monitoring of the queries with high response time, high disk read per execution, SQL Query performance tuning for optimized results using tools like Explain Plan, SQL TRACE, and TKPROF.

Environment: Oracle 10g/11g, Sun Solaris, Linux (Red Hat), VERITAS, TOAD, SQL*PLUS, UNIX Shell, RMAN, 11g RAC, Golden Gate, ASM, OEM, Data Guard, Putty, SQL Server 2008/2005

Confidential, Cheshire, CT

Oracle/SQL DBA

Responsibilities:

• Installed & Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 10g to 11g.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Responsible for Restoration and Recovery of databases at the time 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.
• Achieved High Availability, Data protection and Maximum performance by maintaining a physical standby database.
• Performed automated backups and scheduling using scripting.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Analyzed Alert Logs and Trace Files to resolve the errors.

Environment: Oracle 10g/11g,12c Sun Solaris 5.9, Linux (Red Hat), VERITAS, TOAD, SQL*PLUS, UNIX Shell, RMAN, 11g RAC, Golden Gate, ASM, OEM, Data Guard, Putty.

Confidential

Oracle/SQL DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Re-engineering Customer Cognos and People Soft modules into SQL Server 2005 Integration Services.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Managing the VERITAS net backups.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Monitoring the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Worked with production DBA team in perfect coordination with seniors and team members.
• Involved in gathering requirements from end users.
• Formulated procedures and certified processes for all IT support groups to upgrade database machines.
• Provided technical assistance for daily operation and management of database applications.
• Executed effective processes for management and database administration of Oracle database systems on Exadata.
• Resolved all technical issues relating to database analysis, capacity planning and overall performance.
• Assisted in designing, installation, tuning and upgrading of Oracle database systems.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
• Rebuilding the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Designed and created databases, tables, views, store procedures and triggers.
• Installation and Configurations of Oracle 9i on Linux.
• Creating Database users and granting appropriate privilege, Privileges to Users, Troubleshooting utilities, stripping of the database, Database Sizing.
• Database Designing and Creation as per the requirements, Creating Tablespace and add Datafiles or resizing Datafiles, Changing parameters in pfile / spfile
• Reorganization of the database segments through Storage Parameters.
• Database Security by monitoring User Management, Auditing, Profiling, and Authentication.
• Configuring Listener and Adding TNS Entry in the Tnsnames.ora file for Oracle network configuration.
• Monitoring RMAN Full and Archive backups.

Environment: Oracle 10g, Redhat4, Hp-Unix 10.0, RAC, TOAD, TTS, OEM, RMAN, SQL*Plus, PL/SQL, SQL*Loader, Network setup and Management, SQL Server 2005