SUMMARY

• Venu is a highly motivated Sr. SQL Server DBA/Dev or similar role with 12+years of experience in Database administration, Production support, Development, reporting services using MS SQL Server 2017/ 2016/2014/2012/2008 R2/2005/2000, OLAP, BI Suite (SSIS, SSAS, SSRS) and ETL Processes.
• SQL Server database administration strengths include: Installation, Configuration, Database design (physical and logical) using Erwin, Server and System security, Patching, Database creation, Performance tuning, Change Management, Schema change, Space management, Query optimization, Backup, LiteSpeed, Recovery, Normalization, Hot and Cold Backups, Data conversion, Authorizations, Tables, Indexes, Migration, running Database Consistency Checks (DBCC), Data mapping, Data dictionary tables, Planning capacity, Monitoring growth, Application database replication, Replication server, Logshipping, Database Mirroring, DTS, SSIS, SSRS, Security administration, User administration, Support, Maintenance, NDM (Network Data Mover/Connect: Direct), BMC Patrol, Microsoft Operations Manager (MOM), HP PolyServe.
• Extensive experience in OLAP Cubes, Dimensions/Filters, Data Sources, SQL Server Analysis Services (SSAS), SQL Server Enterprise Manager, Query Analyzer and SQL Profiler.
• Upgrading and Migrating SQL Server 2016/2014/2012/2008 R2/2005 on Clustered and Standby Environments by using In - Place upgrade process and as well as side-by-side upgrade process, and documented the Upgrade Process.
• Auditing of database for user's transaction, login and database action and removing orphan users.
• Implement and manage SQL Azure database for cloud server.
• Good experience in SQL Server Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Experience in supporting Very Large Database (VLDB) more than 20TB and troubleshooting problems.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Setting up and Monitored transactional replication, Snapshot, Database mirroring on Production and QA servers.
• Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries.
• Good experience with implementing DR solution using Logshipping and DB Mirroring.
• Extensively worked on 32bit, X64 bit and i64 clustered and standalone server environment.
• Good experience in creating and maintaining database security policies and SQL Authentication and Windows Authentication.
• Proficient in creation and maintenance of database, creating roles and managing user permissions.
• Performed database design, review and optimize queries to help development teams to achieve better performance.
• Experience in Index tuning wizard for fine tuning the table indexes for better query performance.
• Proficient in maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
• Good experience in SQL Statement performance (indexing, profiler, execution plan analysis).
• Expert in extracting and transforming data between homogenous and heterogeneous systems using DTS/SSIS packages, IMPORT/EXPORT, BULK Insert, BCP and XML Technologies.
• Extensive experience in creating various SQL server objects like database, table, indexes, indexed views, complex stored procedures (dynamic and static), effective functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments .
• Extensively involved in 24/7 Production support of the databases and round-the-clock database operations .
• An enthusiastic and goal-oriented team player possessing good communication, interpersonal skills with good work ethics. Can work in fast pasted environment with multiple teams and clients.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2017/ 2016/2014/2012/2008 R2/2005/2000, Oracle 12c/11g/10g/9i, Sybase, MySQL, PostgreSQL, MongoDB

Languages: T-SQL, C #, Perl, SQL, PL/SQL, XML

Web Technologies: ASP, ASP.Net, VB.Net, ADO.Net, CSS

OLAP & ETL tools: SQL Server Analysis Services (SSAS), Informatica.

Operating systems: Windows Server 2003 EE, Windows 2000 Server/Advanced Server and

Windows 10/8/7/Vista/XP/NT/2000:

Data modeling tools: Erwin, MS Visio.

Monitoring Tools: Tivoli, SolarWinds Ignite, Idera, SQL Server Profiler and Perf Mon.

Version control: MS Team Foundation Server (TFS), HPSM, VSS, CVS, PVCS, Clear Case

Reporting tools: Business Objects/Crystal Reports, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. MS SQL Server DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2017,2016,2014, 2012, and 2008 R2 in development, test, and production environment.
• Configured and Maintained Fail-Over Clustering using SQL Server 2012/2016/2017.
• Experience in Always On environment.
• SQL Server Best Practice Implementation.
• Analyzing problem and Handling Tickets of ServiceNow.
• Experience working with 24 x 7 on call environments.
• Involved in capacity planning, sizing and database growth projections.
• Maintained server and database security including database encryption (TDE).
• Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2008 R2 to 2016/2017.
• Perform day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers .
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues.
• Experience with HA/DR SAN Production environment - Always On, Mirrored Cluster, Log Shipping & Replication.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used Ignite monitor tool to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Creating logins, groups, and users, roles, checking for database consistency, monitoring error logs, database space allocations and transaction log space allocations.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
• Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment: MS SQL Server 2017/ 2016/2014/2012/2008 R2, Always on, Visual Studio 2010/2008/2005 , T-SQL, SSIS, SSRS, Lite Speed, SQL Profiler, Idera, Mirroring, Replication, MS Clustering, ServiceNow, Microsoft Windows Server 2012/2008/2008 R2/2003 32/64 bit.

Confidential, Irving, TX

Sr. MS SQL Server DBA

Responsibilities:

• Performed server installation and configurations for SQL Server 2008R2 and 2012, 2014/2016.
• Migration of SQL Server 2008 to 2012/2014, SQL Server 2005 to 2008 in clustered and non-clustered environment.
• Performed installation of SQL Server Service Packs.
• SQL Server Best Practice Implementation.
• Analyzing problem and Handling Tickets of Salesforce.
• Experience working with 24 x 7 on call environments.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using Lite speed.
• Installed and Configured Transactional and Snapshot replication to replicate data to OLTP and Data Warehousing.
• Used Query Store to troubleshoot query performance, as well as capturing query execution information in SQL Server 2016.
• Perform day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers .
• Used live Query Statistics in 2016 to debugge the Queries.
• Experience with HA/DR SAN Production environment - Always On, Mirrored Cluster, Log Shipping & Replication.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used Ignite monitor tool to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Migrated databases to cloud environment on Microsoft Azure.
• Used SQL Server Profiler, DMV’s to monitor and record database activities of particular users and applications.
• Creating logins, groups, and users, roles, checking for database consistency, monitoring error logs, database space allocations and transaction log space allocations.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
• Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2005, Always on, Visual Studio 2008/2005, T-SQL, SSIS, SSRS, Lite Speed, SQL Profiler, Ignite, Mirroring, Replication, MS Clustering, Salesforce, Microsoft Windows Server 2012/2008/2008 R2/2003 32/64 bit.

Confidential, Grapevine, TX

Sr. MS SQL Server DBA

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• SQL Server Best Practice Implementation.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding/monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Monitoring the servers using Idera third party software.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, SQL Safe, SQL Profiler, Idera SQL Diagnostic Manager, Mirroring, Replication, MS Clustering, Sales force, Windows XP/2000 and Windows 2003/2008/2012 Server.

Confidential, Irving, TX

Sr. MS SQL Server DBA

Responsibilities:

• Performed server installation and configurations for SQL Server 2005 and SQL Server 2008R2.
• Installed SQL Server 2012 on standalone servers.
• Performed installation of SQL Server Service Packs.
• Upgraded databases from SQL Server 2005 to SQL Server 2008R2.
• SQL Server Best Practice Implementation.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using Lite speed.
• Created transactional replication for the reporting applications.
• Implemented disaster recovery solution at the remote site for the production databases using Database Mirroring.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used Ignite monitor tool to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used SQL Server Profiler, DMV’s to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform
• Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Lite Speed, SQL Profiler, Ignite, Mirroring, Replication, MS Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, Houston, TX

Sr. MS SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 R2 on Various Production Servers.
• Migrating Databases from SQL Server 2005 to SQL Server 2008R2.
• Maintained mission critical applications.
• Worked with a team of 6 to manage over 1000 + databases ranging from 10GB to 1.3TB.
• Designed, implemented, configured SQL 2008R2 QA/PROD environment on 6 nodes A/A cluster environment.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Create, deploy, configure and monitor complex ETL/SSIS packages.
• Monitored and modified Performance using execution plans and Index tuning.
• Document server and database policies and procedures.
• Prepared Documentation for the Disaster Recovery plan
• Tested and applied latest service packs and cumulative Hot fix for SQL 2008R2.
• Involved in Change Management, Problem management activities using HPSM tool before implementing database changes in production and development activities.
• Installed and configured SQL 2008R2 Report and Analysis Services.
• Setting up Mirroring & Replication (Transitional) on Production environment.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Responsible routine DBA jobs like Backups and Restores.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Manage and resolve trouble tickets (HP service manager) for database-related issues submitted by customers.
• Working as a team member with other DBA\'s to ensure 24-hour x 7 day a week support of all corporate databases.

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, SSRS, Lite Speed, MSX, BCP, SQL Profiler, Spotlight, IBM Tivoli Monitoring, HPSM, Mirroring, Replication, MS Clustering, Maximo, Windows XP/2000 and Windows 2003/2008 Server.

Confidential

Sr. MS SQL Server DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Coordinating with the Systems Administration team, install and maintain Boardwalk approved application software and systems that integrate with Boardwalk’s database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Accountable for monitoring, troubleshooting, and fixing database issues 24x7x365
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Applied patches and service packs to keep the database at current patch level.
• Monitored and modified Performance using execution plans and Index tuning.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.

Environment: MS SQL Server 2008R2/2005/2000, Oracle 9i, T-SQL, SSIS, SSRS, Report Builder, LiteSpeed, BCP, SQL Profiler, BPA Tool, SQL Diagnostic Manager (Idera), Mirroring, RS Scripter, Altiris 7.1, Mig sp, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, Houston, TX

Sr. MS SQL Server DBA/Dev

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Worked in Active Active Cluster environment as a High availability solution.
• T uning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Extensively used TSM litespeed backups
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Monitored and modified Performance using execution plans and Index tuning.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.

Environment: MS SQL Server 2008R2/2005/2000, Oracle 9i, T-SQL, SSIS, Composite Software 5.0.0, Report Builder, Lite Speed, BCP, Team Foundation Server(TFS) 2008, SQL Profiler, Mirroring, Windows XP/2000 and Windows 2003 Server.

Confidential, Jacksonville, FL

MS SQL Server DBA/Dev

Responsibilities:

• SQL Server 2008 Database Administration.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32-bit and 64-bit clustered and standalone server environments.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Expertise in creating and supporting in OLAP Cubes.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.

Environment: MS SQL Server 2008 R2/2005/2000, SQL Server BI Suite (SSAS, SSIS, SSRS), Log Shipping, Replication, Clustering, MOM, T-SQL, Report Builder, DTS, MySQL, ASP.Net, C#, VSS, ADO.Net, SQL Profiler, OLAP, Windows XP/2000, BCP, Active Directory, Windows 2003 Server.