SUMMARY

• IT professional with over Eight years of experience in SQL server Database Administration and Development using MS SQL Server versions 2014/2012/2008 R 2/2008/2005. Excellent Experience on Installation, Configuration, Patching and Upgrading MS SQL Server 2012/2008R2/2005.
• Configured always - on high availability on distinct work environments like Pre-Production and Production environments. Excellent experience in Disaster recovery plans like Backup/Restore, Log Shipping, Database Mirroring, and Replication. Experience in Database Migration.
• Migrated SQL Server 2008 to SQL 2014, SQL Server 2005 to SQL 2008, SQL Server 2008R2 to 2012. Well experience in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV’s.
• Highly skilled as a Production and Application DBA in Production, QA and Testing environments and also in staging Oracledatabases.
• Skilled in installing, configuring, monitoring and maintaining Oracle Software and patches in 10g/11g/12c on Sun Solaris, Red Hat Linux and Windows platforms.
• Ability to create and modify OracleDatabase objects like Tables, Indexes, Views and Sequences. Experience with Oracle 12c New Features; Grid Control, Automatic Storage Management (ASM).
• Experience in Installation, Configuration, Upgradation and Maintenance of OracleDatabases and Installed, Upgraded and Maintained Oracleon Linux, AIX platforms
• Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automatic administrative task and Configuring Database Mail.
• Expert in developing and implementing Database objects like Stored Procedures, Triggers, Views, User Defined Functions, Indexes, Creating and Updating Tables. Well experienced in dealing with Normalization technique for OLTP and OLAP systems for creating Indexes, Constraints and Table.
• Used Joins and Sub Queries for the simplification of complex queries including more than one tables and defined relationship between multiple tables based on Primary key and Foreign Key constraints.
• Experience in implementing SQL Server security and managing permission to the Database through Database roles, Creating Users and Logins. Experience in writing and tuning T-SQL (Transact-SQL) (DML/DDL/DCL) Queries.
• Hands on experience in maintaining SQL Server Clustering (Active-Active/Active-Passive) and problem solving in it. Experience in Batch processes, Import, Export, Database Monitoring Tools and Application Support.
• Worked on Logical and Physical Database modeling using Tools like Erwin. Implemented new SQL Server 2012 mechanism like Data Compression, Online Indexing, Contained Databases, Security Principals, and AAG.
• Experience in Data ETL (Extraction, Transformation and Loading) using SSIS (SQL Server Integration Services) and SQL Server Reporting Service (SSRS) in SQL Server 2012 with Import/Export Data, Bulk Insert. Experience data warehouse designing using Star Schema and Snow Flake Schema.
• Experience in Creation and deployment of cubes in SSAS and Cube partitioning for optimal performance.
• SQL Server Monitoring and Optimization using third party tools such as Idera SQL Diagnostic Manager, Dell Spotlight for SQL Server/Oracle, SQL Sentry plan explorer for checking query execution plans to get a clear picture of trouble spots.
• Experience in setting-up and monitoring Management Data Warehouse (MDW). Experienced on working with production Servers and 24 x 7 On-Call environments.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills as well as flexible to learn advancements in the IT industry.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005, MySQL, Oracle 11g R2.

SQL Server Tool: SSMS, SSIS, SSRS, SSAS, Enterprise Manager, Profiler, Query Analyzer, DTS.

Languages: T-SQL, ASP.Net, SQL, PL/SQL, MDX/DMX.

Operating System: MS-DOS, Windows 8, 7, XP, 2000, 98; Server 2012R2, 2012, 2008R2, 2008, 2003R2, 2003.

Database Tool: IDERA tool belt, SQL Sentry, Spot Light, Net Backup, SQL Query Analyzer, Index Analyzer

ETS Tool: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Migration Assistant (SSMA), MS SQL Server Reporting Services (SSRS).

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Database Administrator / Production Support

Responsibilities:

• Installed, Configured and Maintained SQL Server 2008/2012 in multiple database environments. Applied Service Packs & assisted Infrastructure Engineering team to install and configure SQL Server in a Clustered (Failover) Environment.
• Installed and configuredOracle 10g RAC in Sparc/Solaris and Dell/Linux platforms. Also Install Oracle Critical Patch Update (CPU) patches for Windows and Unix/Linux environments. Successfully installed and configured Oracle 11g Data Guard on UNIX/Sun Solaris platform.
• Handled Performance Tuning and Optimization with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Creating new databases, maintaining existing databases, creating schemas, roles, tables, views, materialized views, database links and other supporting artifacts, assigning privileges, and evaluating and tuning Oracle and SQL statements.
• Migrated data on different Oracle versions of 11g (11.2.0.4) and 12cR1.
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Performed the migration from SQL server 2008 to SQL 2014 following the Normalization standards to maintain data consistency. Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process.
• Detecting and troubleshooting VM related CPU, memory, I/O, disk space and other resource contention using VM vSphere tools, Event Viewer and System Console operation monitoring tools. Responsible for the issues related to Database Integrity, Blocking, Dead Locking issue, Replication.
• Responsible for installation, configuration and Patching of SQL Server 2012/2008/2008 R2. Worked on Priority 1 and 2 Critical Incidents to meet the Response and Resolution Service Level Agreements (SLA). Responsible for over 200 SQL instances globally.
• Work on SQL Development to write and troubleshoot SQL Code, and Designed by using database objects like Triggers, stored procedures, functions, tables, views and Constraints.
• Work on data Extraction from various sources like SQL Server 2008/2012, CVS, Oracle, Teradata, Excel and Text file from Client servers and through FTP.
• Work on backups, restores, recovery models, database shrink operations. Maintained and supported internal database repository and managed the service and application creation/deletion, and associations with SQL server instances.
• Maintained database integrity of all vendor and in house databases. Archiving the databases and Decommissioning De-supported SQL instances which are not in use by any application to avoid the licensing costs. Scheduled the DTS package for migration data from old system to MS SQL 2005.
• Generated reports from the cubes by connecting to Analysis server from SSRS. Worked among Technical Architects and Database analysts for the Design of total tables required for efficient Report Design. Database mirroring, Replication.
• Deployed the post-build Perl and Power Shell scripts at the server level, and post-install SQL scripts for enabling monitoring and native backups through SQL Agent jobs.
• Worked in cooperation with System Administrators for configuration of Windows failover cluster and implemented SQL Server Always On.

Environment: SQL Server 2005, 2008, 2008R2, 2012, 2014; TSQL, VMware vSphere Client, Oracle 11gR2 and 12c Windows Server 2003, 2003R2, 2008, 2008R2, 2012; Symantec Net Backup, IBM InfoSphereGuardium, DBLaunch, HP Service Manager, Vormetric Transparent Encryption.

Confidential, San Francisco, CA

Sr. SQL Server DBA

Responsibilities:

• Work on configuring and maintaining all three types of replication like transactional snapshot and merge replication. Installed, configured and maintained MS SQL fail over clustering for critical production servers.
• The work involves overall maintenance ofORACLE database, performance issues, tuning, backup, recoveries and other database related activities.
• Installed and Configured Oracle Data guard forOracle11g &10g for the maintenance of Stand by database.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.
• Query Optimization handled by using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005. Responsible for implementation and Release of Database changes as per the requirement of Application Team. Generate billing and posting it to the finance tool (GP).
• Developed the Billing script as a Stored Procedure and make changes to meet business requirements and also implemented various logics to handle multiple scenarios as per Business need. Developed stored procedure, Triggers, Cursors, Joins, View and Databases using MySQL.
• Worked with the application teams to identify the feasibility of migrating legacy databases to consolidated SQL Server 2012 environment.
• Performed SQL instance version upgrades from SQL 2000 and 2005 to 2008. Carried out Performance tuning of the databases. Implemented High Availability and Disaster Recovery solutions with SQL Server DB Mirroring, Log Shipping and Failover Clustering (Active-Passive).
• Configured Data guard to Create and maintain Physical standby database. Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc. Created Database and Server level Audit specification using the SQL Server Audit Feature and analyzed the audit results.
• Created a SQL Batch Job of the same and maintained to the optimal needs. Used new features like row and page compression mechanism, Data Compression, and Backup.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts. Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Managed Capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory. Experienced with SSIS packages, SSRS and SSAS features in SQL Server 2005 servers.

Environment: SQL Server 2000, 2005, 2008R2, 2012, SSRS SSIS, MS Outlook, TSQL, SAN, Visual Studio 2010, TFS (Team Foundation Server), ASP.Net version 2.0.

Confidential, S an Francisco, CA

SQL Developer/DBA

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, and views and Join statements for applications by using T-SQL. Worked with Technical Architects and Database analysts for the Design of total tables required for efficient Report Design.
• 24x7 Production DBA support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor. Created and managed table spaces, data files, resizing and adding new data files.
• Managed table spaces, temporary table spaces, and redo log groups. Responsible for logical and physical data modeling, Designing Database, star schema, data analysis, programming, documentation and implementation. Involved in creating Named calculations and named queries.
• Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes. Installed new SQL instances, applied service packs, performed in-place and side-by-side upgrades based on the build requests.
• Proactively disabled login IDs based on the Aveksa Dormant Account Locking reports. Extensively Used SQL Server tools and applications like SharePoint, Redgate, idera, Backup Exec, SCOM, Erwin, Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system SProcs.
• Performed Periodic Production and Non-Production SQL Server VM farm maintenance. Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Implemented 2008R2 features like Unicode compression and Report Builder 2.0/3.0.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Modified VB & Java DAO (Data Access Objects) to point to SQL Server from Sybase and Oracle. Prepared the reports for the daily as well as weekly/monthly purposes in Different formats like MS Excel, PDF, HTML, and XML etc.
• Troubleshooting issues in Production, Development, QA, and Testing environments. Performed routine and customary operational and monitoring activities to ensure the database environment is stable and capable of meeting ongoing business needs.
• Monitored performance using AWR and ADDM Reports. Monitoring alert log for critical errors, and space utilization issues. Creating Automatic data loading Procedures from the host system to master systems. Tuning front-end applications like Visual Basic and MS Access, which query the databases.
• Troubleshooting ODBC and OLEDB issues between the application and the server.

Environment: HTML. MS SQL Server 2005/2008R2/2012, SSRS, SSIS, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access Reports, Sybase, Oracle.

Confidential

SQL Server DBA

Responsibilities:

• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security. Carried out Reporting using Crystal Reports on SQL Server 2005 databases.
• Created Logins for the users, granted database privileges as per the request and security guidelines of the organization. Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• SSRS Administration including configuration, security management, trouble shooting and monitoring. Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube. Developed, implemented, and tested backup and recovery plans.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency. Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Experienced with SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.
• Worked with the system administrators, network, backup, and storage engineers to migrate all databases, procedures, and reports into a central data warehouse as a continuous effort. Implementing Disaster Recovery for minimal downtime using backups, restore, and replication.
• Involved in restore operations to refresh the data from production to test servers. Support a production system setup comprising of Sybase ASE servers, Replication Servers.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server. Performed compression of historic data for VLDB and compressed backups to save disk space.
• Upgraded SSIS Packages from SQL Server 2005 to SSIS packages in SQL Server 2008 database. Experienced with creating database maintenance plans for efficient operations. Involved in upgrading from SQL Server 2000 to SQL Servers 2005.

Environment: SQL Server 2000/2005, T-SQL, SSRS, SSAS, ASP.Net, Crystal Reports 10.0.

Confidential

Database developer/ Administrator

Responsibilities:

• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.). With SQL Server, performed backups (Full, Diff, Transaction log) and restores.
• Performed the migration from SQL server 2005 to SQL 2008 following the Normalization standards to maintain data consistency. Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process.
• Created Drill down Reports, Ad-hoc Reports and Drill through reports using the ROLAP as a source. Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Developed Physical data models and created DML scripts to create database schema and database objects. Created and maintained clustered and non-clustered indexes; Rebuild and reorganized indexes; Found missing indexes and dropped unused indexes to increase performance.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping. Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Designed stored procedures for module integrity and application.
• Wrote and Optimized Stored Procedures, Views, and User-Defined Functions for the application. Created Database, creating tables, indexes, stored procedures, triggers and constraints. Experienced with SSIS packages, SSRS and SSAS features in SQL Server 2005 servers.
• Worked in ASP.Net Web forms, State management and Caching feature. Successfully implemented Database mirroring on SQL 2008 Servers for Disaster Recovery and monitor databases involved in mirroring sessions.
• Performed Database cloning and restoration in UAT and Development environments. Involved in installation, upgrade, patching and configuration of Microsoft SQL Server and databases.

Environment: SQL Server v2000, T-SQL, Win NT v4, Win 2000, MS Excel, ASP.Net.