SUMMARY

• 8 years of experience in Oracle Database Administration, tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10gRAC with ASM and single instance database.
• Extensive working experience in Oracle Database …   SQL, PL/ SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views,   SQL   Loader
• Used range and list partition technique for larger table partitioning.
• Oracle Database Administration in a variety of environments like Oracle Linux, HP - UX, IBM-AIX, Sun Solaris, RHEL.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Having very good exposure in automated maintenance plan according to type of   server . 
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
• Experienced in working in collaborative team environment with other developers, business analysts, and a project management team. 
• Extensive knowledge of maintaining   SQL   authenticated and Windows authenticated logins /users and grant proper privilege. 
• Strong experience in capacity planning, implementing backup and recovery strategy for application and database. 
• Expertise in implementing Database Mirroring in   MY SQL   Server   2012 and 2016 for high availability.
• Expert in implementing Log Shipping Technique used for warm standby solution for My   SQL   Server databases. 
• Experience in implementing Snapshot and Transactional replication models. 
• Experienced in implementing TDE (Transparent Data Encryption) to secure data at rest and document the process. 
• Extensive experience in MS   SQL   Server   Business Intelligence. 
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using   SQL   Profiler, Perform Counters and Spotlight. 
• Extensive knowledge of configuring Database mail in   SQL   Server   2012 and 2008. 
• Experience with Toad Data modeler and Generate detailed reports on existing database structure
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by O patch utility.
• Experience in database full Backup (hot and cold), Incomplete Backup, Data Pump Export/Import, SQL Backtrack and Restore procedures.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Installed 12c Grid agent on servers and configure 12c OEM Grid control.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Experienced in logical and physical database design and development, normalization, data modeling and   SQL   server   Enterprise Manager/ SQL   Server   Management Studio. 
• Expert in using tools like MY SQL   Profiler, Index tuning wizard, Windows performance for monitoring and tuning   SQL   server   performance . 
• Extensive experience in using T- SQL   for developing complex stored procedures, triggers, tables, views, user functions, user profiles, relational database models and data integrity,   SQL   joins and query writing. 
• Experience in implementing the new features of My SQL   Server   2008 such as Policy Based Management, Backup Compression and Transparent Data Encryption . 
• Knowledge of new features in   SQL   server   2012. 
• Experience in using Oracle Streams for replication of database.
• Job scheduling using corn, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, and Recycle Bin.
• Documented all Oracle database installations and database operations
• 24*7 Production Database Support to ensure availability, efficiency and recoverability. Co-ordination with Oracle Corporation for technical support, new products and releases, technical discussion/support.
• Hardworking, result oriented good interpersonal and communication skills.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, 12c MY SQL Server 2000/2005

DB Management Tools: Oracle enterprise manager SQL PLUS, SQL Developer, Toad, Export & Import utility, Data Pump, RMAN, Golden gate, APEX, EMC Data storage, very data with, SSH, Data Guard 9i/10g, TKPROF, Stats pack, Discoverer, SQL navigator, Oracle reports, OAM, OEM, MS Office, MS Visio, Informatics 8, Congas, MS Visio, RAT, AWS, Explain Plan, Cassandra, Putty, AWR/ASM/ADDM/ASH, VM Ware Work station, Virtual box.

Operating System: RHEL Sun Solaris, HP-UX, IBM AIX, UNIX

Languages: C, C++, PERL, SQL, PL/SQL, UNIX Shell, T-SQL

Other Software: Understanding of Networking

Web Server/Tools: IIS, Web sphere

PROFESSIONAL EXPERIENCE

Oracle DBA

Responsibilities:

• Maintain and Support Oracle databases 12C, 11g R1/11g R2/10gR2/10gR1/9iR1/9iR2 in Solaris, AIX, and Oracle Linux platform.
• Patched and upgraded the Oracle databases.
• Involved in installation of   SQL   Server   2012 and   SQL   Server   2016 in newer environments. 
• Installed and Applied patches to the existing   SQL   servers   and Upgrading   SQL   servers . 
• Installed   SQL   Server   Active-Active and Active-Passive clusters. 
• Configured   SQL   Server   jobs for Index maintenance, Database Consistency jobs, Database backup jobs and Alerts. 
• migrated databases using GG and RMAN for 2 node RAC
• Responsible for support of 1000+ Production databases of Terabytes in size, 2500+ UAT, DEV & TEST databases sizing 100G to Terabytes.
• Active member of Conversion team; as part of this team, I have migrated Legacy NCC databases to new Oracle standards. This includes setting up backup strategy, Oracle database environment
• Worked with on RAC resolutions on hang check timer, split brain, RAC recovery, ASM, OCR corruptions.
• Optimized the performance of queries with modifications in T-SQL  queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Developed YU customized programs running through Banner Job Submission such as Faculty assignment upload and Employee salary increase.
• Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup and recovery using RMAN, Trouble Shooting production issues, Physical Database design.
• Managed the databases in Sun Virtual Environment. Also maintained the database which had O/S cluster for failure scenario.
• Worked with Grid Control for various day to day Oracle DBA tasks.
• Resolve Incident and Service Requests in the tickets queue and proactively resolve database related problems, based on alerts triggered by OEM or BMC Patrol Monitoring Tool.
• Support and monitor databases to ensure Service Level Agreements on uptime, capacity, health and functionality.
• Used Oracle Apex for various tasks like managing database inventory etc.
• Actively maintained Oracle Database Project, this has 4 production RAC databases (sizes 20+ TB) with each 8 nodes, 15+ DEV/TEST/QA/Break FIX 8 node RAC environment.
• Collaborate with Oracle Support for bugs & issues resolutions and personal research.
• Provided valuable inputs for various performance tuning issues.
• Worked with crontab and Oracle Jobs to manage, schedule various database jobs for backup, maintenance, password change etc.
• Refreshed non-production environments from production database backup for developers.
• Followed change control, Information Security and IT audit standards and procedures for any DBA activity.
• Analyzed, planned, managed and evaluated processes that determine database quality, design and functionality per SAS standards
• Worked collaboratively with developers and management to establish Oracle development and production standards.
• Developed task definition and execution strategies.

Environment: Oracle 9i, 10g, 11g, 12C, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Stats pack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring,   SQL   Server   2012 Enterprise, Windows Enterprise   Server   2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services..

Oracle DBA

Responsibilities:

• Created 3 production physical standby databases and 9 non-production physical standby databases.
• Worked with Real Application Cluster (RAC) databases.
• Installed, created and 10g and 11g databases and Clients.
• Install and configure Oracle software.
• Extensively worked on Dynamic Management Views in   SQL   Server   2008.
• Installed, authored, and managed reports using   SQL   Server   Reporting Service s. 
• Managed the migration of   SQL   Server   2008 databases to   SQL   Server   2012. 
• Monitored   SQL   server   performance using   SQL   Profiler to find performance and dead locks. 
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. 
• Refresh schema level and full level production to non-production databases.
• Creation of database objects like tables, views, materialized views, procedures and packages  using oracle tools like Toad, PL/SQL Developer  and SQL* plus.
• Designed the database schema and create any necessary database objects.
• Formulate optimal application SQL using Grid Control and V$Queries.
• Ensured database security is implemented to safeguard the data.
• Work closely with developers and system administrators to ensure all database needs are being met.
• Applied patches or upgrades to the database as needed.
• Used SRVCTL utility for managing multiple instances and nodes.
• Responsible for having multiple OCFS locations in RAC environment.
• Managed and multiplex Voting Disk and OCR file for maximum RAC availability.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Perform Backup and Recovery thru RMAN.
• Written RMAN scripts for purging out applied logs at standby databases.
• Performance Tuning of database, SQL tuning for Application
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan
• Mapping of old data fields to new model data fields for data migration
• Estimate System/Database performance.
• Worked very closely with development team
• Application Database connectivity using ODBC and Oracle Net configuration.
• Created number of UNIX shell scripts for various tasks.
• Performed various UNIX Administration tasks.
• Automated various tasks thru crontab.
• Written Backup and Recovery scripts using RMAN
• Performed Export/Import of Oracle 8i/9i and 10g Databases thru command line as well as performed import export interactively.
• Performed Export/Import thru Data Pump.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Applied various database and Application patches
• Used Grid Control for Backup and Recovery tasks.
• Solved database connection issues using Oracle Net Services.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments

Environment: Oracle 9i, 10g, 11g, 12C, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Stats pack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, MS   SQL   Server   2008/r2 Enterprise Edition, MS   SQL   Server   Reporting Services 2005(SSRS), MSSQL   Server   Integration services(SSIS).

Oracle DBA

Responsibilities:

• Lead activities for decomposing product requirements into tasks and associated estimates
• Mentors the team on technology concepts and ensures team compliance to best practices for design
• Mentors the team on the best techniques to debug and troubleshoot issues
• Participates in code and design reviews to ensure quality and conformance to product standards
• Participate in Oracle Best Practices and new product web presentation.
• Helps motivate team members to get the best out of team.
• Installed 10g/11g databases and Clients on RHEL and other win/*ix platform.
• Configure ASM packages on Linux.
• Installed ASM disks.
• Manage ASM disk groups via ASMCMD and database control.
• Managed 4 node RAC cluster.
• Troubleshoot RAC issues with olsnode, crs stat, crs register, crs unregister, crsctl, cssd, crsctl, srvctl etc.
• Multiplex OCR and Voting Disk to different location for higher availability.
• Add and delete node in RAC environment.
• Stop and start nodes via srvctl and manually.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages  and procedures.
• Reconfiguring Services via srvctl utility
• Worked with Oracle to solve multiple RAC issues
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues.
• Configured and Administered Oracle 10g/11g RAC high availability on ASM.
• Installed and configured OEM Agent.
• Upgrading database from Oracle version 10g to 11g. 
• Used Export/Import and Data pump utilities for full/partial backup.
• Optimal Sizing of Instance memory pools like SGA, dB buffers, shared SQL area, log buffer based on the requirements.
• Maintained different homes for Oracle 10g/11g and ASM.
• Created and maintained additional ASM disk groups according to the necessity.
• Build and configure physical standby Data Guard
• Database cloning/refresh from production to production reporting, Backup and SIT.
• Implemented and maintained full, incremental and cumulative RMAN back up’s on NAS storage.

Environment: Oracle 9i, 10g, 11g, 12C, Unix shell script,\, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR, EXP/IMP, PL/SQL

Oracle DBA

Responsibilities:

• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Setup physical standby database to protect mission critical from any failures, errors or corruptions·
• Configured ASM for RAC setup and non RAC databases.
• Worked closely with application developers and system administrators to ensure all database needs are being met.
• Managed databases with size more than 2 TB.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Applied various database and Application patches
• Used Grid Control for Backup and Recovery tasks.
• Solved database connection issues using Oracle Net Services.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments
• Worked very closely with ORACLE for Data Guard implementation and other major issues.

Environment: Windows2000, TOAD, Oracle 9i, PL/SQL, Oracle DBA Enterprise Manager, SQL*Loader, Shell scripts

Oracle DBA

Responsibilities:

• Installed, Configured and upgraded DB2 server software and related products
• Troubleshot day-to-day problems encountered on production, development and test database environment.
• Designed, implemented and administered DB2 UDB for development, test and production environments.
• Migrated Dev, Prod databases from DB2 9.5 FP 5 to DB2 9.7 FP 4.
• Developed and implemented standards to create databases and various database objects
• Took online and offline backups as well as wrote shell scripts and scheduled them
• Requested space for file system and raw-devices to UNIX group
• Wrote shell scripts in Unix (AIX/Solaris/HP) with a good understanding of UNIX servers and architecture
• Cataloged multiple instances and configuring connectivity to databases from remote clients
• Tuned Database Manager configuration parameters as needed
• Bind the server DB2 utilities to the databases
• Requested TSM management class from the TSM administrator and Configure Database parameters to use TSM management class
• Extensively involved in Application Support, Design, User Administration, Security, Performance Tuning, Optimization and Backup/Recovery
• Drop and add users, logins, aliases, and groups to the databases and granting/revoking permissions on Database objects.
• Installed DB2 10.1 AESE on sandbox and working on Prototype scenarios for replication.
• Supported On call weekly based 24/7.

Environment: Windows2000, SUNSOLARIS, Oracle, PL/SQL, Oracle DBA Enterprise Manager, SQL*Loader, Shell scripts