SUMMARY

• Over 8+ Years of total IT experience including SQL Server Database Administration for very large and complex databases in SQLServer2000/2005/2008/2008/ R2/2012/2014/201
• Knowledge to lunching EC2 Instance server in Amazon web services (AWS) cloud across multiple availability zones
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Sound knowledge of Stored Procedures, Indexed views, User Defined Functions (UDF), Triggers, Distributed Queries, and Common Table Expressions.
• Having hands on experience working with HA/DR SAN Production environment - Clustering, Always-On High Availability groups, Mirroring, Log Shipping, &all types of Replication techniques.
• Expert in applying latest Service Packs, Patches, and Hot fixes for SQL Server.
• Experience with Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency.
• Involved in SQL Server 2016/2014 environment tech refresh and data center migration.
• Implemented Disaster Recovery Solutions by configuring SQL Server in Log Shipping and Mirrored Environments.
• Extensive knowledge in developing and deploying ETL packages using, DTS, Informatic, SSIS for accessing heterogeneous data, data cleansing and auditing.
• Expertise with the role of Transaction logs and action accordingly Log Space Maintenance and Temp database space issues.
• Expert in automating the system by using SCOM and creating alerts, jobs and maintenance plans.
• Solid experience in performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, Fog light, Spotlight, SQL Diagnostic Manager, DMVs and DMFs.
• Involved in ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects. Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in Huge data migrations and Data center migration, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Used Microsoft Azure using Power Shell to generate query results for SQL Server.
• Hand full of experience in using third party tools like Idera, Lite speed, Red gate.
• Flexible, enthusiastic, and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Extensive experience in SQL Server development, stored procedures, User defined functions, Triggers, Views, Indexes, data integrity. Worked with Problem Ticket (PTs)/Work request (WRs) for prod and lower environment issue and change request (CRs)/Work Order (WOs) for Prod deployment.

TECHNICAL SKILLS

Operating System: Windows 2000/2005/2008/2012 Server, Windows 95/98/XP/NT, Linux, Solaris, Unix

Databases: MS SQL Server 2016,2014, 2012,2008 R2,2008, 2005,2000, Oracle 8i,9i, Sybase

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, ER Diagrams Performance Monitor, Log Shipping, SSIS, SSRS, SSAS, Microsoft Clustering Services (MSCS), PowerShell, PDW

Programming: T-SQL, PL-SQL, HTML, HTML5, XML, CSS, C, C++

DBA: Database administration of MS SQL Server 2016, 2014, 2012, 2008 R2,2008, 2005,2000

Data Migration: SSIS, BCP, Data Migration, Import/Export Wizard

Backup Utility: Quest Lite speed, SQL Safe, Redgate, Tivoli, Idera

Build Tools & Analytical Tools: FreeNAS, OWNCLOUD, Virtual Box, NODE-XL, MS Project and Visio

PROFESSIONAL EXPERIENCE

Confidential,Oakland, CA

Sr. SQL DBA and developer

• Responsible for requirement gathering from Business users.
• Worked in designing, creating, and deploying SSIS packages for transferring data from flat files, excels spreadsheets, Oracle, Salesforce, and heterogeneous data to and from SQL Server.
• Improved query performance by adding covered indexes, adding file groups etc.
• Developed and implemented web applications using HTML, JavaScript, and SQL server stored procedures.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Created packages in SSIS with error handling using various data transformations.
• Created and deployed Reports utilizing SSRS to design complex reports.
• Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
• Implemented subscriptions and snapshots in the SSRS Report Manager, report security, report delivery. Integrated reports from SSRS with SharePoint.
• Crested customized applications using JavaScript and CSS to accommodate business needs.
• Created dashboard, scorecards, and KPIs.
• Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
• Worked closely with Micro strategy team for reporting requirements.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.

Environment:SQL Server 2008/2012, SQL, Enterprise manager, JavaScript, SSAS, SSIS 2008/2012, SSRS, MDX Cubes, SQL Compare, SQL Data Compare, UC4/Atomic, Rally, SQL Sentry, DTSX change, PDW .

Confidential, Hamilton, New Jersey

Sr. SQL DBA

• Involved in installations, upgrades, patches, and fixes.
• Migration of databases from SQL Server 2008R2/2012 to SQL Server 2012R2.
• Involved in the complete lifecycle and capacity planning of mission critical Databases.
• Monitoring and Troubleshooting jobs in Production, Preview, and Development environment.
• Providing 24x7 supports to Production, Preview, and Development servers.
• Involved in Health Check process for SQL Server databases using Database Maintenance Plans.
• Assisted in the design and development of the Data Modeling and Data Warehouse design.
• Replaced a transaction log replication with mirroring on a report server and took reports from snapshots of the mirror database.
• Coordinated physical changes, current space utilization and performance monitoring of two replicated production servers and two development servers.
• Designing Logical and Physical Data Models with Visio.
• Increased the availability of production databases by setting up mirroring.
• Conducted performance tuning on regular basis to improve performance of slow running queries and stored procedures.
• Implemented Security, which included creating Logins, Users and granting permissions to users.
• Managing security roles in SQL Suite& Install updates and patches.
• Maintained cluster servers to provide high availability.
• Created and tuned stored procedures, triggers, and tables.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T- SQL code from developers and QA
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Configured two Active/Passive Clustering setups for failover on production servers.
• This included installing windows cluster service and SQL 2012 on windows 2012 enterprise edition.

Environment: SQL Server 2000/2005, T- SQL, SQL Server Agent, SQL server Profiler, Data Tuning advisor, Mirroring, Disaster Recovery, APS.

Confidential, Raleigh, NC

Database Admin

Responsibilities:

• Involved in migration of database from MS SQL Server 2012/2008 and Oracle 9i to Oracle 10g, working with database monitoring and tuning.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and kern shells, Unix shell Scripting.
• Performed tablespace, dataset, and transaction recoveries at various instances.
• Maintained efficient and reliable backup and recovery routines
• Supported application programmers and users in their daily interactions with DB2.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Created Views, User Defined Functions, and Triggers.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Supported team in resolving in DTS and T-SQL related issues in SQL Server DBA.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database ADFA.
• Performed Database Tuning, Performed Database Security, and Integrity.
• Created partitioning of its types like Range, List & Hash by the specific use.
• Cloning of databases from production to development and test databases, used RMAN for Backup & Recovery.
• Reviewing performance stats and recommended changes for tuning SQL queries, database, server, and storage configurations in SQL Server Database.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server-sideT-SQLscripts for data manipulation and validation and created various snapshots and materialized views for remote instances in SQL Server Database.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Meta link.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation, and Shell scripting.
• Installation, configuration, and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Performed Data guard switch over to check the standby database is coordinated with production as per the business requirement and operated standby database using Data Guard broker
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Space management of logical structures (i.e. table spaces, rollback segments) and auditing of users.
• Involved in performance tuning and monitoring of T-SQL blocks in MS SQL Server Database.
• Used SQL Profiler and Query Analyzer to optimize DTSpackage queries and stored procedures.
• Setup/Managing both Oracle & MS SQL Server Databases on Amazon RDS.
• Created and maintained DDL for all MS SQL Server Database & Oracle Database.
• Develop and/or optimize automated database administration processes and procedures to reduce overall man-hours needed to support existing DB2 infrastructure.
• Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements.

Environments: MS SQL Server 2000/2005/2008/2012/2014/2016, Windows 2003/2008/2012, SSIS, SSAS, PL/SQL, MS Access, Perl script, Log Shipping, Replication, TSM/TDP, Golden Gate, SAN, NAS, RMAN, ETL, Oracle 11g RAC, 10g RAC, T-SQL, Oracle 9i, Oracle 10g, APS .

Confidential, Ervin, NC

SQL Server DBA

Responsibilities:

• Hand full of experience in using third party tools like Idera, Lite speed, Red gate.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating, and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: SQL Server 2000/2005, T-SQL, CVS, Windows NT/2000/XP

Confidential, Charlotte, NC 

Junior Database Admin

Responsibilities:

• Provided 24/7 support and maintained terabyte size of databases.
• Involved in migration of MS SQL Server 2005/2008 to MS SQL Server 2008 R2.
• Performed capacity planning to create and maintain corporate databases and processing demands across various sites.
• Created complex Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Simplified complex queries with multiple tables using Joins and sub-Queries.
• Engaged and administered MS SQL Server by creating user logins with appropriate roles, groups by granting required privileges to users and groups.
• Created Stored Procedures, ad-hoc queries, dashboard reports and Scheduled to run them by creating SQL Agent Jobs.
• Monitored High Availability of the servers and various data transfers between various servers using BCPand DTS packages.
• Modified existing databases and database management systems with the help of indexes, tables, partitions, triggers, constraints, stored procedures, large objects, views etc.
• Administered all database objects, including tables, clusters, indexes, views and sequences, packages, and procedures.
• Deployed administration tools like SQL DB Access, Performance Monitor, and Backup Utility along with monitoring tools like Site scope and spot light.
• Migration of database from Oracle 9i to Oracle 10g, working with database Monitoring and Tuning.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and kern shells, Unix shell Scripting.
• Implemented procedures to detect poor database performance, system integration checks and root cause analysis, performance tuning and query optimization.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Increased team productivity and automated repetitive tasks by using batch files, PowerShell, VBScript and WMI.
• Designed and facilitated the implementation of data warehouses required by application systems
• Supported OLAP team to providing data from SQL Servers.
• Published the databases from old servers to new servers using snapshot replication.

Environment: SQL Server 2000/2005/2008, 2008 R2, Oracle 8i, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0, and Microsoft Reporting services 2.0., PowerShell, VBScript, OLAP, DTS Packages, BCP.