SUMMARY

• SQL SERVER and ORACLE DBA with over 5years of hands on experience. Experienced with Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, High Availability and Disaster recovery, performance monitoring and tuning, Oracle Goldengate, Data Guard.
• Superb Knowledge of MS SQL Server versions 2008 - 2016
• Experience with oracle database versions 10g, 11g and 12c
• Experience in installing OEM 12c Cloud Control and upgrading 11g management agents to 12c
• Experience in database upgrade and migration.
• Created physical standby Data Guard using RMAN
• Experience in RAC Installation and Administration on Linux Platform
• Experience in troubleshooting and resolving database installation issues, integrity issues, performance issues, blocking and deadlocking issues.
• Experience in tuning database and memory components for optimal performance using tools such as AWR, ADDM, ASH, Explain plan and Optimize.
• Strong experience with Performance Tuning and query Optimization using in-built tools (SQL Profiler, Extended Events, Query store) and external tools (IDERA)
• Resource Government
• Knowledge with Azure
• Experience with Vault manger, SharePoint, Netsmart, ServiceNow, SolarWinds, Commvault and Veeam.
• Experience with High Availability and disaster recovery solutions- Log Shipping, Always on Availability Groups and Database mirroring ( SQL server) and unidirectional and bi-directional Golden Gate, Data Guard and RAC ( Oracle)
• Expert in backups, restores and recovery processes.
• Expert knowledge of Database Security, TDE, security profiles, data Masking, data redaction, Auditing, Logins.
• Experience working with Windows server with a working knowledge of general Datacenter operations both physical and virtual.
• Installed 12c Database and responsible for upgrading Oracle 10g to 11g .
• Experience working in an agile project methodology.
• Expert experience in implementing operational automation
• Expert Knowledge on indexing and index management .
• Knowledge of SSIS and SSRS
• Experience supporting application Development request for database/schema refreshes
• Expert knowledge of oracle 11g and 12c installation, patching, upgrades and administration

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c. MS SQL Server 2012-2016

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, DBCA, DBUA, ADDM, Azure Monitor, Toad, Putty, NX client, Winscp, VN, Sql Developer, SQL Server Management Studio, Iginite/DPA, MobaXterm, Cisco Automatic workload Automation, OEM 12c

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Other Skills: Microsoft Azure, Azure Virtual Machines, SSIS, RAC, GOLDEN GATE, DATA GUARD, AZURE CLOUD

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Database Administrator

Responsibilities:

• Responsible for monitoring and making recommendations/implementation of performance improvement in hosted HA databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases
• Maintained SQL Server Databases; ensured accuracy of information and automated numerous functions.
• Create and manage Oracle 12c container and pluggable databases
• Fine tune database objects and server to ensure efficient data retrieval.
• Monitor and optimize system performance using SQL Profiler, extended event and Database Engine Tuning Advisor.
• Install, manage and provide day to day administrative support for SQL server 2012, 2014 and 2016
• Participate in on call rotation
• Experience in Batch processes, Import, Export, Backup, Recovery, Database Monitoring tools and Application support
• Involved in the migration of on premise databases to Azure cloud
• Plan, Design and Scheduled Database Maintenance & Administrative Tasks
• Performance Tuning - Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector and Resource Governor
• Administer and support databases in log shipping configuration.
• Expertise in T-SQL writing stored procedures, triggers and functions
• Implemented & Administered SQL Server High Availability and Disaster Recovery strategies Alwayson Availability groups.
• Experience in using DMV and dynamic management functions for finding out long running queries
• Installed, upgraded and patched and managed Oracle Databases on 10g to 12c on Linux OS
• Monitored and managed databases in RAC environment
• Migrated on-premises databases to Azure cloud.

Confidential, San Francisco, CA

Database Administrator

Responsibilities:

• Plan, install, and test software upgrades and patches.
• Have implemented physical standby database supported by Data Guard in 11gR2
• Migrated both oracle databases and tablespaces between same platform and different platforms.
• Used explain plan, Oracle hints and the creation of new indexes to improve the performance of SQL statements.
• Monitor database performance trends to identify anomalies or errors.
• Develop, plan, and establish database performance baselines.
• Test and coordinate database modifications.
• Plan and coordinate security measures alongside Banner Security Administrators and Database Administrator Manager.
• Create and maintain all SQL Server databases required for development, testing, education and production usage.
• Experience with cold/ Hot Backup, Recovery and Cloning of databases using RMAN
• Perform ongoing tuning of the database instances.
• Install and configure new instances of the SQL Server .
• Periodically test the databases backup and recovery process.
• Implement and enforces security for all of the SQL Server Databases.
• Monitor log shipping configuration
• Perform database re-organizations as required to assist performance and ensure maximum uptime of the database.
• Enforce established standards to ensure that all application design and code is produced with proper integrity, security and performance.
• Perform reviews on the design and code frequently to ensure the site standards are being adhered to.
• Help evaluate releases of SQL Server and its tools, and third party products to ensure that PCOM is running the products that are most appropriate.
• Provide technical support to the Enterprise Applications Team.
• Enforce and maintain database constraints to ensure integrity of the database.
• Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Assist with impact analysis of any changes made to the database objects.
• Respond to and resolve database access and performance issues.
• Perform database transactions and security audits.
• Establish appropriate end-user database access control levels.