PROFESSIONAL SUMMARY:

• 6+ years of Experience as Microsoft SQL Server 2005/2008/2008 R 2/2012/ 2014/2016/2017 Administrator providing support to Production, Test and Development environments.
• Hands on experience in installation, configuration, administration, Performance tuning, patching, upgrades, migration, backup and recovery, cloning, space management, database security, auditing, and managing SQL Server 2017/2016/2014/2012/2008 R2/2008/2005 and Oracle 10g/11g/12c databases.
• Expertise in upgrading (In - place Upgrades) and migrating SQL Server in clustered (active/active, active/passive) and non-clustered environments from lower versions to SQL Server 2012/ 2014/2016/2017 .
• Experience in implementing different types of SQL Server DR (disaster recovery) scenarios like Log Shipping, Mirroring (High safety, High performance & High availability), Replication (Snapshot, Merge and Transactional) and Clustering.
• Strong Expertise in designing Databases, Developing Stored Procedures, Triggers, Views, User Defined Functions, Table Design, Index Design, Maintenance Design for performance improvements, writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.
• Hands on experience in Database Backup and Recovery procedures for SQL Server & Oracle databases.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Experience working with entire BI stack including SSIS, SSRS, and SSAS.
• Deployed cubes in SSAS environment with good understanding of conceptual data warehouse.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Lookup, Conditional Split, Bulk Insert, Merge and Merge Join.
• Experience with Microsoft SQL Server and Oracle Transparent Data Encryption (TDE) techniques, Row-level, Column level and Table Space level encryption.
• Good analytical, interpersonal and communication skills and very proactive by nature which benefits in working in groups.
• Strong Expertise in migrating SQL Server and Oracle databases from Windows to Hyper-V environment.
• Planned and Configured HA & DR solutions for SQL Versions & Oracle11g & 10g, Standby Database (Oracle Data Guard).
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Experience in performance tuning, identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries and handling them by implementing better Query execution plans.
• Experience working with 24x7 Production support and On-Call rotation with various Ticketing and Change Management.
• Database backup and recovery, Involved in development of scripts to automate backup and recovery procedures for development databases.
• Experienced with TFS, Service Now, change management and Help desk ticket management Processes.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Hands on experience in Database Backup and Recovery procedures for Oracle and SQL Server databases.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005/2008/2008 R 2/2012/ 2014/2016/2017 , Oracle 10g/11g/12c

Operating Systems: Windows 7, Sun Solaris 5.8, 5.9, 5.10, HP-UX 10.x, 11.x, RHEL 5.x, 6.x, AIX 5.x, 6.x and Windows NT 2003/2008/2012/2014.

Tools: SQL Server Management Studio, Query Analyzer, SQL Server Profiler, SSIS, SSRS, SSAS, Performance Monitor, DTS, Management Studio/Enterprise Manager, Query Analyzer, Oracle Enterprise Manager, SQL*Loader, Erwin, Data Pump, Exp\Imp, TOAD, Index Tuning Wizard, AWR, ADDM, TKPROF, Business Intelligence Development Studio (BIDS), BMC Patrol, Zabbix, Control-M, Solarwinds.

Languages: T-SQL, SQL, PL/SQL, C, C++, VB, HTML, UNIX Shell Scripting, Ksh, bash and PERL Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria,VA

SQL Server DBA

Responsibilities:

• Extensively worked on refreshing TDE encrypted databases from Production to Staging and Development using Powershell.
• Upgraded SSIS packages from SQL Server 2012 to SQL Server 2017 and troubleshooted issues with upgradation.
• Migrated SSIS packages from SQL Server 2012 to SQL Server 2017.
• Migrated Databases, logins, Jobs from SQL Server 2014 to SQL Server 2017 using Powershell.
• Patched SQL server SP3 and CU3 on SQL server 2017 using Powershell and patched windows core.
• Performed GDPR delete and info requests using command shell.
• Extensively worked on Always on with Replication environments.
• Configuration, administration and developing for MS SQL Server 2014+.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures. Design and implement resilient, highly-available systems, monitoring/alerting, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of assets.
• Respond to and resolve databases security, access, and performance issues. Monitor database system details/diagnostics within the database, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize and allocate physical storage for systems. Develop, implement, and maintain change control and testing processes for modifications to databases.
• Extensively worked on Performance tuning and database monitoring via Solarwinds.
• Responsible for disaster recovery and high availability solutions.
• Extensively worked on extended events and SQL Profiler.
• Automated scripts used to update all objects in instance level which has ‘..’ with ‘.dbo.’
• Worked on tickets as Tier 1 support related to Connection issues, Access issues, Database restores, Development and staging system refreshes and database issues.
• Worked closely and communicate with internal customers and project owners in a collaborative and receptive manner.
• Written automated scripts to purge huge data and scheduled job.
• Documented all the issues encountered and all the important activities accomplished in the environment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Perform 24x7 support for critical production systems.

Environment: MS SQL Server 2014/2016/2017 , SSIS, windows 2012/Core, Visual Studio 2012/2017, Enterprise and Standard Edition, Clustering, Always On, Mirroring, Replication, T-SQL, SSMS, Powershell, Slack, Zendesk, Solarwinds, SQL Profiler, Extended Events.

Confidential, Suitland,MD

SQL Server DBA

Responsibilities:

• Performed installations of SQL Server 2012/ 2014/2016/2017 and applied Security Patches, Service packs hotfixes on Clustered and standalone servers.
• To provide support for the Production databases and application issues.
• Migrated SQL Server Databases off legacy environments onto the Enterprise Servers, worked with the Application team to fix the issues that occurred during this transition.
• Developed stored procedures, functions, views, triggers, created indexes, constraints and rules on database objects.
• Worked with third party tool- SQL Server Commvault to backup\restore the databases.
• Evaluated Database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Implementation of SQL server logins, Roles as per the security policy.
• Continuous monitoring of SQL Server\Databases overall health, available resources with monitoring tools and to take the appropriate steps to resolve disk space, IO, server, network related issues.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Worked with database tuning advisor, SQL server profiler and activity monitor for Performance tuning.
• Used DBCC and DMV commands for day-to-day troubleshooting tasks.
• Deployment of databases, jobs, from pre-production to production.
• Monitoring routine database maintenance tasks for updating statistics, checking fragmentation, index rebuilds, checking database integrity and backup plans.
• Data refresh from production to test and development, maintain Database Security.
• Worked on Service Requests, Change Requests, Incidents and deployed DDL scripts throughout the SDLC.
• Responsible for migrating SQL Server and Oracle databases from Windows to Hyper-V environment.
• Worked on documentation according to the business/users requirement.
• Maintained day-to-day production support, check error logs to capture any possible errors to ensure the databases health.
• Developed several SSIS packages in SQL Server 2008R2/2012/2014 using Business Intelligence Studio and created the jobs to schedule the SSIS packages in SQL Scheduler.
• Deployed cubes in SSAS environment with good understanding of conceptual data warehouse
• Worked off hours coordinated with teams for downtime.
• Worked on day to day activities like restoring the databases, backups, created logins, fixed performance related issues.
• Performed database access control, incident management, database security. As part of the access control elevated access were removed.
• As part of best practices db owner access is granted only on Sandbox environments and worked with the application teams to implement this transition.
• Participated in (BCP) projects and tests to ensure high availability of our critical production databases.
• Worked on entire BI stack, SSIS, SSRS, SSAS.
• Administering SQL Server High Availability and Disaster Recovery strategies
• Worked with IT and R&D teams to engineer and implement new data security tools and processes such as Data Loss Prevention, Digital Rights Management and encryption technologies
• Implemented features like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing (Oracle and SQL Server)

Environment: MS SQL Server 2008/2008R 2/2012/2014/2016 , SSIS, windows 2008/2012, Visual Studio 2012, SSIS, T-SQL, SSMS, Commvault, SSRS, Sharepoint, BMC Patrol, Jira, Confluence, Zabbix, Appdynamics, Powershell, Linux.

Confidential, Pittsburg,PA

SQL Server/Oracle Database Administrator

Responsibilities:

• Migrated SQL server 2008/2008R2 databases to SQL server 2012 databases by In-place upgrade process and used upgrade advisor tool in up-gradation.
• Created new database logical and physical design to fit new business requirements, and implemented new design in SQL Server 2005/2008/2008 R2/2012.
• Controlled and Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Managed SQL Server using PowerShell.
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Used log shipping for synchronization of database.
• Actively participated in gathering User Requirements and System Specifications.
• Configured and maintained SQL Server high availability solutions like Replication (Includes both snapshot & transactional), log shipping and Database Mirroring.
• Configured and implemented Always On in SQL Server 2012 as per the HA/DR solution.
• Worked closely with application developers throughout the life cycle process, especially to aid and ensure efficient database design, stored procedures and SSIS packages.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Migrated SSIS packages from SQL Server 2005 to SQL Server 2008/2008R2/2012.
• Monitoring and Troubleshooting of Database Replication issues.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in complete SSIS life cycle in creating SSIS packages deploying and executing the packages in both the environments (Development and Production).
• Perl Scripting, Shell Scripting, Bash Scripting and PL/SQL Programming to resolve business problems of various nature.
• Installation, Configuration and deployment of Oracle 11g databases, backup & recovery.
• Experience in Installation and configuration of Grid Control and administering Oracle database using Oracle Enterprise Manager Grid Control and TOAD.
• Handled database upgrade and migration from 10g to 11g and 11g to 12c.
• Configured replication using Oracle Golden Gate at schema level uni-directional, bi-directional.
• Responsible for taking weekly backups of data using DATAPUMP and RMAN.
• Applying CPU patches, Oracle patches, Release upgrades, ONE-OFF patches.
• Interacted with Oracle Support regarding multiple service requests to solve performance issues of the Database. Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and rewriting the SQL queries to improve the performance.
• Worked on day to day activities like restoring the databases, backups, created logins, fixed performance related issues. Performed database access control, incident management, database security.
• Strong passwords in the database are enforced when technically possible, and database passwords are encrypted when stored in the database or transmitted over the network.
• Experience with implementing and deploying security (encryption, anonymization, data integrity, policy control) features in large scale infrastructures.
• Understood the significance and use of encryption and tokenization for data protection.

Environment: SQL Server 2012/2008R2/2008/2005, SSIS, Business Intelligence Studio, Visual Studio 2012/2010 /2008 , SharePoint 2010/2013, Oracle 12c/11g, Linux, HP, AIX, RMAN, SQL*Plus, PL/SQL, UNIX Shell Scripting, OEM Grid Control, Data pump, AWR, ADDM, GoldenGate, Jira, Confluence, Zabbix, Appdynamics, OEM GC

Confidential, East Hanover, NJ

Database Administrator

Responsibilities:

• Involved in migration of databases from MS SQL server 2005 to MS SQL server 2008/2008R2, MS SQL server 2008/2008R2 to MS SQL server 2012.
• Refreshing the databases of all environments from production database and Creating Database links according to the Business requirement.
• Supporting Regional Data Centers and Corporate 24/7 Production databases and responsible for round-the-clock database operations, offering solutions for Production/Development of database applications.
• Implemented Active/Passive and Active/Active clustering based on the project needs with tight timelines.
• Plan, establish, maintain and monitor high availability for all production database servers including clustering, availability groups, database mirroring and log shipping.
• Involved in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Knowledge of implementing SQL Server Service Broker.
• Actively involved as part of team for gathering and analyzing the needs of end user requirement and system specification.
• Created many AD HOC Reports using MS Reporting services and Crystal reports for private business that is used to run daily according to the business requirement.
• Worked on applying patches and service packs to keep the database at current patch level.
• Deploying cubes in Analysis Services.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008R2/2012 Analysis Services (SSAS).
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Installation, Configuration, administration and migration of Oracle databases.
• Created stored procedures, Functions, Common Table Expressions and Triggers.
• Assisted in design of tables, databases, oracle forms, and reports; connected forms with Oracle Applications
• Performed automated data loads with SSIS, provided data pulls according to the business requests.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Created/Troubleshoot DDL scripts that effect schema structure validating Build Scripts against “standards” and previous environments for consistency creating, updating, scheduled jobs and stored Procedures.
• Assess and recommend alternative processes, procedures and tools to streamline operations and provide a more efficient and cost effective database environment.
• Developed, tested, debugged and documented Oracle PL/SQL packages, procedures, PL/SQL and types in accordance with company policies, company standards and industry best practices
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Change management controls are in place to log all changes to the production database.

Environment: Windows Server 2008 R2 Datacenter, Windows 2003 Server, SQL Server 2005/2008/2008 R2/2012, Visual Studio 2008/2010, T-SQL, MS-Excel, ASP.NET, VB.NET, SQL Server Reporting Services, SSIS, BCP, SQL Profiler, TSMNetApp, HHPC Clusters, UNIX.