SUMMARY

• 8+ Years of Experience as Deployment Specialist DBA supporting builds, releases and documentation
• 7+ Years of experience in Data Modeling using ER/Studio and CA ERwin Data Modeler
• 7+ years of experience in MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ Performance Point (on SharePoint)/MDS/DQS/Data Mining
• 5+ Years of experience in supporting and maintaining Microsoft MDW databases
• 5 + Years of supporting Reporting via Native Tools, Crystal Reports and Microstrategy.
• 8+ Years of experience on MS SQL Server 2000, 8+ Years on MS SQL Server 2005, 5+ Years of experience on SQL Server 2008, 2008R2 and 4 Years on SQL Server 2012 and 2 Years on SQL Server 2014 and 1 Year SQL 2016 on physical, virtual and cloud environment.
• 3+ Years of experience in supporting GIS Applications via SQL Server and Oracle.
• 3+ Years of experience in supporting Pro SQL Databases on Windows Azure
• 7+ Years of experience in enabling and deploying SOX, GXP, HIPAA & GRC compliances
• 3+ Years of Experience in Configuration of Database mail, linked Servers, Transparent Data Encryption (TDE) and Auditing
• 7+ Years of experience in Extraction, Transformation and Loading (ETL) (Microsoft SSIS)
• 7+ Years of experience in Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
• 7+ Years of experience in Report Development (Microsoft SSRS)
• 7+ years of experience in writing Perl, SQL, Shell and Power Shell scripts for tasks automation, alerts and monitoring
• 7+ Years of writing queries and developing modules, stored procedures and functions using TSQL & SQL
• 5+ Years of experience in SQL Clustering, 7+ Years in Replication & Log Shipping, 5+ years on database mirroring and 4+ Year on SQL Server Always On High Availability
• 5+ Years of work experience with Microsoft Visual Studio (2010 & 2013)
• 7+ years of experience in capacity management and capacity planning.
• 7+ Years of experience in supporting DBA Services via Incident Management, Problem Management and Change Management
• 7+ Years of experiencing in participating, documenting and performing Changes, Root Cause Analysis (RCAs) and Root Cause and Corrective Actions (RCCAs)
• 7+ Years of experience in Project Lead, DBA Tower Lead, Team Lead, Technical Lead People Management and Project Management.

PROFESSIONAL EXPERIENCE

Confidential, DALLAS - TX

MS SQL Server DBA

Responsibilities:

• Expertise in Installation, Upgrades, Patching and Configuration of MS SQL Server 2014,2012, 2008R2 & 2008 in different 32/64 bit production, test and development environments.
• As a part of SQLDB team, was primarily responsible for planning DR, ensuring databases are online and providing infrastructure and application DB support. Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
• Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS. Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows Server.
• Involved in ensuring data recovery, maintenance, Data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server Environments.
• Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export.
• Designed and implemented SSIS packages to migrate data from multiple data sources on Windows 2003/2008/2008 R2/2012/2012R2, MS SQLServer 2005/2008/2008 R2/2012.
• Support new SQL Server database builds and projects (includes Installation, Backups, Monitoring and Security Hardening.
• Upgrade Versions of SQL 2000, SQL 2005, SQL 2008 databases to 2008 R2, 2012 and 2014 on Virtual and Physical Servers environment
• Support new builds, releases, deployment &Source Code Management manually or third-party tools.
• Manage Azure based OLTP & reporting environment.
• Manage backup, restore and migration for Azure SQL Server Databases
• Used dynamic SQL to reuse the code part of the stored procedure. Implemented Transactions like BEGIN/ROLLBACK/COMMIT based on the needs. Key feature in Dynamic SQL like Param definition to define it as output and retrieve it by using SP EXECUTE SQL.
• Experienced in Encryption of Databases on Master DB level, Table level and column level using self-signed certificates and TDE keys for securing the top priority data.
• Worked in implementing SQL Security and object permissions like maintenance of database creating and users and logins assigning roles to the users and managing user permissions.
• Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.
• Implemented Encryption of data on stand-alone instances and AOAG instances using Master Keys, TDE and Certificates
• Maintaining the AWS portal in creating the databases and archiving the logs and data in AWS.
• Participated in Maintenance activities of AWS cloud. Writing stored procedures, functions and complex T-SQL queries in AWS Cloud.
• Worked on inbound and outbound data migrating from AWS Cloud to SQL.
• Used Information Schema views, SYSTEM. Triggers, SYS.dependencies for various database applications needs to verify the common columns/Key columns list between the tables, finding the triggers list on a table and finding the dependencies of an object.
• Implemented several types of Replication Models like Snapshot, Merge and Transactional using SQL SERVER2008.
• Configured High Availability using widows clustering
• Used performance tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Used Common Table Expressions (CTEs) to avoid sub queries.
• Added error handling techniques like TRY-CATCH and THROW syntax in the procedures.
• Experienced with Clustering setup and Active Directory in Windows 2012.
• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability. Generated Scripts for lower version of SQL Server, Changed Compatibility level and data and log file location, executed the scripts using cmd commands.
• Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
• Worked with importing flat files and XML files, Share Point, fetched data from other data source like MS Access, DB2, MySQL, Oracle and ETL to the database. Created UNIX shell script to move file across the servers and automation of daily tasks.
• Implemented AlwaysOn Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster for high availability and disaster recovery.

Environment: Windows Server 2012 Enterprise Edition, MS-SQL Server 2 / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, TFS, PowerShell, SSIS, ERP, SSRS,, Unix, Linus, T-SQL, Visual Studio 2013/2012/2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Confidential, Chicago

MS SQL DBA

Responsibilities:

• Managed and Administrated theSQL Server 2014/2012/2008 production and Non-production servers.
• Installed and configured SQL Server 2014/2012/2008 R2/2008/2005 clustered and standalone servers and applied security patches.
• Handled the upgrade of SQL Server 2014/2012 and worked on applying the security patches and hot fixes.
• Worked on high availability SQL server solutions, including Always on availability groups, log shipping, mirroring and SQL server clustering.
• Created and managed schema objects such as tables, views, indexes and referential integrity, stored procedures converting them into technical specifications.
• Worked on detecting and resolving locks and deadlocks using the trace flags and native tools like profiler and the activity monitor.
• Involved in implementation of replications (snapshot and transactional) in OLTP environment.
• Installed and configured a SQL 2012 clustered environment with Always on availability groups.
• Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
• Effectively used DBCC commands, dynamic management views (DMV), SQL profiler, performance monitor, SQL server management studio, trace analysis and execution plans as part of troubleshooting and performance tuning.
• Worked on analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
• Performed daily tasks including backup and restore by using SQL Server tools like SQLserver management studio, SQL server profiler, SQL server agent, and database engine tuning advisor.
• Assigned permissions to user(s), role(s), and object. Support column level permission; administrate security for server's logins (windows and SQL accounts).
• Created complex SSIS packages using proper control and data flow elements and deployed the packages and scheduled them.
• Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution
• Implemented Active / Active Clustering and Active Passive Clustering as a disaster recovery solution.
• Dexterity inimplementingdifferent types ofHigh Availability & disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping,Database mirroring and clustering.
• Extensively worked with SSIS packages in creating reports using excel and xml files, used an ETL tool to pull data from SQL server (OLTP) to Teradata (data warehouse).
• Provided alerts through email, scheduling tasks and to generate scripts during migration.
• Performed Backup and recovery &automation of Backups using maintenance plans.
• Involved in administering, maintaining, developing and recommending policies and procedures for ensuring the security and integrity of the company's databases.
• Create Database(s) on SQL AZURE, involved in setting up SQL Azure Firewall
• Worked on setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS)
• Upgraded/Migrated SQL Server 2008/2005 databasestoSQL Server 2014/2012 databases.
• Familiarity with Amazon Web Services, Installed, configured and Monitor MSSQL Database Backup on AWS.
• Performedbackup using backup compression and Data compression in SQL Server 2014, 2012, 2008 on clustered environment.
• Ordering and Preparing the Servers for the Migrationin new Data Centre.
• Installed the SQL Clusters for New Data Centre.
• Handled upto 2.5 TB Size databases with clustered environment. Implemented AlwaysOn availability groups.
• Application support for front end feeds and ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev servers.
• MonitoredLog shipping/ Transactional Replicationand troubleshooting of errors.
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Worked on Oracle Database by Data-fix's and DBCR'S using UNIX.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeOracle, DB2 to SQL server.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• Involved in Database Modeling, Database Mapping, And Normalization Using ERWIN.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
• Create SQL logins for windows authentication, SQL authentication and Active Directory.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.

Environment: Windows Server 2008/2010/2012 Enterprise Edition, MS-SQL Server 2008 R2/2012/2014, IIS, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Studio 2010, Sybase, MYSQL, Unix, Linux, Toad, Indexes, LogShiping, Active Directory, .Net Framework 3.5, snapshot, Replication, MS Office suite 2010.

Confidential

MS SQL DBA

Responsibilities:

• Involved in beginning of the project, updated existing database from SQL server 2005 instances to SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
• Design primary-standby databases (Manual log shipping to the same servers) setup for existing applications running in SQL server 2008 Standard Edition and Enterprise Edition.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Installed, configured, operated and troubleshot Windows SharePoint Portal Services. Created and maintained websites using Windows SharePoint Team Services.
• Involved in Design of Data warehouse using Kimball and Star Schema and created Fact tables and dimension table.
• Created cubes and configured and deployed cubes using SSAS.
• Created XML files by using SSIS Package Configuration. Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).
• Moved SQL server objects among test, QA and Production environment. Took full, differential and Transactional backup of databases often and moved them to external tape storages.
• Used DDL to define indexes (keys), specifies links between tables, and imposes constraints between tables.
• Delivered SharePoint training to users and administrators.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Created Logical & Physical Database modeling for in house development application. Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using the concept of OLE DB.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• OLAP Created, altered, maintained system roles and permissions to users on various database objects.
• Responsible for creation of new database objects like stored procedures, tables, view, triggers, function according business logics. Inserted XML file parameter in to the database tables using services.
• Used Rational Rose/MS Office Suite for creating use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models.
• Worked with IBM Rational Clear Case and Rational Clear Quest to automate and enforce the development processes and aid with configuration management.
• Audited database user’s audits using SQL profiler and costumed stored procedures/packages.
• Loaded flat files into stage tables by using Bulk Copy Program BCP and DTS packages. Scheduled database jobs for automation of DBA tasks.
• Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Developing various simple to complex reports using different Reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports and Business Objects.
• Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources and ETL related operations. Partitioned large tables1.2 million rows tables using range partition.
• Providing high availability SQL Server solutions, including Log shipping, Mirroring, Snapshot and Replication.
• Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Developed complex reports and provided to business people for further analysis. Responsible for make changes in application according to business logic.
• Faced, resolved connectivity issues and ODBC with front end application languages ASP.net, VB.net and C#.net. Responsible for connectivity issues to the database, IIS 6.0 and VERITAS Cluster software among servers.
• Involved inStaging PartitionsandUsage Based Optimization (UBO)mechanisms for SSAS 2012 and 2008 OLAP databases.
• Involved inTabular Data warehouseoperations for SSAS 2008 OLAP databases.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.

Environment: Windows NT/2008, MS SQL Server Management Studio 2008 R2, T-SQL, DTS, SSIS, SSRS, SSAS, TFS, Replication, Oracle 9i, Rational Rose, Informatica 8.6, PL/SQL, SQL*Plus, SQL*Loader, Shell scripts, .NET Framework 4.0, VB.NET, C#.net, Visual Basic 7.0, Visual Studio 2008, ERwin 4.0.5, ODBC, AIX 5.3

Confidential 

MS SQL DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environmentsand applied service pack.
• Active involvement in installing and managing failover clusters set up in active/passive environment as a High Availability mechanism.
• Implemented Database Mirroring between Production instances.
• Rebuilding and monitoring the indexes at regular intervals for better performance.
• Resolved Deadlocking, Blocking and locking issues by creating a trace using SQL Profiler.
• Maintaining SCOM Monitoring Tool on Database Servers for extensive monitoring, alerting and auditing the application, OS related errors.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Ensured data backup and recovery, maintenance, data integrity and space requirements for the database server environments.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created and Managed User Permissions, Logins and Configuring Security Per Organizational Standards.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS.
• Analyzed the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Scripted the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Migrated data from SQL Server 2005, SQL Server 2008R2
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2008R2/2005 for achieving performance enhancement.
• Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of users, applications.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Provide 24 X 7 support to all Production, QA & Development MS SQL Server Environments.

Environment: MS Office suite 2000, MS-SQL Server Management Studio 2000/2005, T-SQL, DTS, Replication, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, MS Access, Erwin, SQL Query Analyzer.