SUMMARY:

• Around 6+ years of experience in Information technology having excellent experience in MS - SQL 2008R2, 2012, 2014,2016 servers and Oracle database administration. Involved in database design, development and testing on production and non-prod environments.
• Extensively worked on installation, configuration, migration, upgradation, monitoring, space management, database backup, recovery procedures and troubleshooting.
• Migrated databases and upgraded the versions from SQL 2008R2 to 2012SP2 and 2012 to 2016 SP1.
• Implemented high availability & disaster recovery techniques with ALWAYS ON Failover clustering, Database Mirroring, Transactional Replication and Log Shipping.
• Experience in implementing SQL Server security by creating users, roles, configuring permissions, database authentication modes and assigning roles to users.
• Implemented database and backup security with encryption and always encrypted features.
• Involved in performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs and Windows viewer and Performance monitor.
• Excellent experience in creating database and database Objects like Tables, Stored Procedures, Views, Triggers, User defined data types and functions.
• Experience in creating scheduled tasks for regular database backup and maintenance activities.
• Extensively used native and third-party tools like SQL profiler, Tuning advisor, Performance Monitor, Resource monitor and Litespeed.
• Excellent in writing SQL, T-SQL queries and stored procedures as per the business requirements.
• Experience in stored procedures code review and documenting best practices.
• Good knowledge on implementing ALWAYS ON AVAILABILITY GROUPS
• Good Knowledge on SQL Server licensing model.
• Extensively worked on Linux and windows Operating systems.
• Familiar with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation
• Incident Management and Change Management Requests on Production, UAT and QA Servers were Handled and Resolved Using Service now application. .
• Ability to work on multiple tasks in a fast-paced environment independently and in a team.
• Excellent experience on Oracle core database administration.
• Good hands on experience in implementing high availability and disaster recovery solutions using RAC (Real Application Cluster) and Data guard.
• Successfully implemented 3 nodes cluster with ASM on Oracle 11g.
• Implemented Physical and snapshot standby databases using DataGaurd.
• Expertise in collecting and diagnosing the TKPROF, AWR and ADDM reports for performance tuning.
• Experience in migrating databases from 11g to 12c.
• Experience in migration of databases from non-RAC to RAC and non-ASM to ASM.
• Excellent experience on backup and restore process using RMAN and data pump utilities.
• Extensively used Oracle Enterprise Manager 12c for administration.

WORK EXPERIENCE:

Confidential, CA

SQL DBA

Responsibilities:

• Installing, configuring, managing, monitoring and troubleshooting SQL Server 2014/2012/2008 R2 versions in a clustered and standalone environment.
• Migrated SQL Server 2008 to 2012. Also, created detailed documentation of steps taken during the migration process.
• Provided High Availability and Disaster Recovery Solutions using Backup and Restore, Replication and Always On.
• Upgrading the existing servers with Service Packs, Patches and Hot fixes.
• Configured extended events for SQL tracing.
• Tuned long running queries by utilizing DMVs and Query Tuning Adviser wizard.
• Involved in change writing, Peer review and code deployment to production and staging environment.
• Involved in restore operations to refresh the data from production to test servers.
• Monitored database status including CPU, memory, I/O, space, blocks using SQL Server Utilities.
• Regular monitoring of SQL Server Agent jobs, checking event logs and error logs of any issues.
• Involved in troubleshooting clustered and standalone environment issues.
• Implemented the TDE in all the Production servers.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Reorg and rebuilding the indexes at regular intervals for better performance.
• Incident Management and Change Management Requests on Production, UAT and QA Servers were Handled and Resolved Using Service now application.

Environment: Microsoft SQL server 2016/2012/2008 R2, SQL profiler, Tuning advisor, SSMS, Windows Enterprise Server 2008R2 and 2012 cluster, ServiceNow, T- SQL, SSRS, Linux 6.8, MySQL, service now Incident management tool

SQL DBA

Responsibilities:

• Installed and Configured SQL Server 2012 on clustered environment and standalone machines.
• Performed backup using backup compression and encryption in MS-SQL Server 2008R2 on clustered environment.
• Implemented high availability on the various servers using Replication, Log-Shipping and Mirroring.
• Implemented and tested the point in time recovery of the production databases.
• 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.
• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Successfully implemented physical standby database using Oracle 11g Data Guard feature for High availability and Disaster Recovery purpose.
• Installed and configured 2 node oracle 11gR2 RAC with ASM on Linux RHEL 6.1 for production environment.
• Identified index fragmentation and rebuild of indexes.
• Applied relevant patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering Statistics.
• Wrote shell scripts for automation of tasks and used shell scripts with crontab for job scheduling.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created necessary templates for various requirements gathering and documentation.
• Monitored Log shipping and Transactional Replication and troubleshooting of errors.

Environment: SQL Server 2012,2008r2, SSRS, SSMS, SQL Profiler, Performance Monitor, Microsoft Excel, Oracle 12C/11g, Oracle Enterprise manager 12c, RMAN, DataGaurd, RAC, SQL developer

Database Engineer

Responsibilities:

• Provided ongoing support for MS-SQL and Oracle database servers which include Installation, configuration, Upgradation, Migration, Maintenance and Troubleshooting.
• Created alerts, notifications and emails for system errors, insufficient resources, database, hardware, and security errors.
• Configured and Managed the High Availability and Disaster Recovery Solutions, Mirroring, Replication, Active-Active and Active-Passive Clustering on Critical Production Servers.
• Scheduled the database backups and recover the databases from backup in disasters using Point-In-Time Recovery solutions.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Encrypted data and log files using transparent data encryption (TDE) solution.
• Created and Scheduled jobs, alerts jobs to capture any possible errors.
• Migration of Oracle Databases from NON-RAC to RAC and NON-ASM to ASM.
• Installation and creation of Oracle10g, 11g Databases for production, test, dev servers.
• Implementation and support of Oracle 11g and 12c migrations and upgrades from Oracle 11g to 12c database.
• Set up Disaster Recovery using DataGaurd physical standby databases for mission critical Oracle databases.
• Implemented snapshots on a separate instance to use it as a reporting server minimizing load on production using DataGaurd.
• Tested Oracle 12c regression testing prior to production implementation for a 900GB oracle DB.
• Performed database tuning using Explain Plan, Tkprof, Statspack and other custom utilities.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Provide support for 12c Oracle Enterprise Manager Grid Control and Agents.
• Maintain, schedule and troubleshoot all RDBMS related software Oracle Enterprise Manager (OEM) Cloud Control 12C on Linux and Unix Environment.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Worked on Flashback to restore on point in time recovery.
• Restored/Refreshed downstream Oracle database instances for various DEV, QA and UAT purposes.
• Managing Tablespaces, Data files, Rollback segments, Temporary TBS.
• Proficient in using Flashback technology, Log Miner, Automatic Storage Manager.
• Maintain, upgrade, troubleshoot all Enterprise oracle and SQL server databases
• Clear communication and documentation of technical specifications.
• Used Jira and Confluence tools for Issue tracking.

Environment: Oracle12c/11g, SQL server 2012/2008,SSMS, RAC, Datagaurd, Datagaurd broker SQL, PL/SQL, RMAN, ADDM, AWR, ASM, Stats pack reports, Shell Scripts, SQL Developer, RHEL-6.3/6.4, Windows server 2008r2, Jira, Confluence, SVN, Eclipse IDE, Perl scripting

SQL DBA

Responsibilities:

• Responsible to Install, Configure and maintain SQL-Server 2008R2 on test and development servers.
• Performing backup and recovery
• Implement and maintain database security.
• Troubleshoot and minimize production down issues.
• Running DBCC consistency checks, and fixing data corruption in application databases. Monitor failed and long running MS SQL Server jobs
• Responsible to both manage and support oracle databases with sizes varying from 50 GB to 500GB.
• Installed and Upgraded 10g to 11g.
• Perform daily administration support for database backups, performance tuning and monitoring.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked on Data pump to take the logical backups of databases.
• Worked on performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.
• Performance tuning via OEM, STATSPACK/AWR for 10g/11g.
• Maintenance tasks like bouncing the production database, services through Veritas.
• Installed IBM db2 database on AIX servers
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Environment: Windows server 2008 R2, SQL Server 2008R2, Oracle 10g, Jira, SQL Developer, Enterprise Manager, batch scripting.