We provide IT Staff Augmentation Services!

Sr.mssql Server Dba Resume

San Antonio, TX

SUMMARY:

  • Extensive experience developing and working with diverse collection of applications and around 10 +years of professional experience as Microsoft SQL server database administrator and developer.
  • Extensive experience in maintaining Very large databases (VLDB) SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000/7.0 environments.
  • Experience working on SQL Server 2012 and knowledge on 2014.
  • Installed and configured the thresholds in IDERA Diagnostic manager tool on Prod and test Servers.
  • Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
  • Experience in Migrating from SQL server 2000 to 2005 and 2000/ R2, 2012 by using side - by-side upgrade process, and documented the Upgrade Process.
  • Extensively worked on Backup compression and data compression in SQL Server 2008.
  • Knowledge on Always availability group and columnstore index features in 2012.
  • Experience in designing, developing and maintenance of databases in MS Access. Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers.
  • Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 and 2012 on VMware Environment.
  • Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
  • Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active/Active and Active/Passive) and Database Mirroring.
  • Worked with Tivoli Data Protection (TDP) and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008.
  • Configured the always-on availability feature in SQL 2012.
  • Installed the oracle client 11g,12c.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS)
  • Expertise on physical storage SAN configuration on different RAID levels.
  • Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
  • Hands on experience with administering large databases, managed databases of size above 3 terabytes, database design, normalization and database application development using varied development tools.
  • Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
  • Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
  • Experience in trouble shooting sql server jobs, and job monitoring tool.
  • Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
  • Auditing of database for users transaction, login and database action and removing orphan users.
  • Use CDC to extract rows that have been inserted, updated, or deleted via T-SQL queries
  • Expertise in using DBCC trace flags, handling blocking and dead lock situations.
  • Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, Index Tuning Wizard and Windows Performance Monitor.
  • Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
  • Creation and maintenance of Databases, creating Roles and managing user permissions.
  • Experience in Troubleshooting and documenting root cause analysis.
  • Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
  • Explicitly used third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager (TSM).
  • Worked on Business objects issues and documented the solutions.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
  • Develop and manage reports on SharePoint Server.
  • Checking the threshold values and baselines and monitoring in perfmon and SCOM.
  • Rebuilding indexes with different fill factors and updating statistics.
  • 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2012/2008 R2/2008/2005, 2000/7.0, Oracle, MYSQL, MS Office Access 97/2000/2003 T SQL, C, C++, C#, vb.net, JAVA, ASP.NET, Visual studio 2005/ 2003, XML

Technologies: VB.NET, .NET FRAMEWORK, ASP.NET, Microsoft Office Suite

Tools: Active X, IIS, MTS, Lite speed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0, SSIS, SSRS, SSAS, SCOM, Tivoli TSM,solarwinds

Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008 R2/2012, Windows 95/98/XP/Vista/7

Others: Microsoft office, Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr.MSSQL SERVER DBA

Respobilities:

  • Installation and Maintenance of SQL Server 2008/2008 R 2/2012/2014/2016 on Production, Development and Test Environments along with configuring the drives according to the standards and policies.
  • Capacity planning of databases according to client requirements.
  • Supported 24 X 7 Production environments and solved many incident Tickets.
  • Set up Always on Availability Groups as a high availability for group of databases in SQL 2014 instance.
  • Worked on very large and complex databases and in a highly transactional environment.
  • Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
  • Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
  • Implemented in memory OLTP feature in SQL Server 2014.
  • Migrated databases from SQL Server 2005/2008R2 to SQL Server 2008 R2/2012/2014
  • Migrated SQL servers from physical to VMware virtual environment.
  • Installation of SQL Server 2014/2012/2008/05 and service packs on Windows Server Clustered environment.
  • Prepared maintained and modified SQL server installation and configuration documents.
  • Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
  • Implemented native log shipping on MS SQL SERVER 2008R2/2012.
  • Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully
  • Installed and managed the databases in Oracle. And also load the tables in oracle database using Toad and SQL developer tool..
  • Taken the backup of oracle database RMAN.Dialy worked on Refresh database request tickets and also adding the space in the database.
  • Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
  • Extensively worked on trouble shooting and fine-tuning of databases for its performance using Database tuning advisor and SQL server profiler. Identifying and recommending the resolutions for the failed jobs in all the production servers.
  • Capturing long running SQL queries for fine-tuning SQL statements that had better result in efficient SQL statements processing.
  • Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
  • Rebuilding indexes with different fill factors and update statistics manually.
  • Good hands on experience in Change Management, Incident and Problem management.
  • Involved in capacity planning, sizing and database growth projects.
  • 24*7 On Call production support.

Confidential, San Antonio, TX

Sr.SQL Server DBA

Responsibilities:

  • Attended the every week synch up call with Bexar County team to discuss the status of the project, issues and what need to improve on database performance
  • Gathered the information of SQL inventory using the map tool in different domains like server details, SQL server version and details, Instance name, cpu details, Disk information, edition, Memory.
  • Bexar team identified the top priority Databases to do analysis on them like finding the long running query, last access tables, trigger information, Database details, and Index information.
  • Involved in the daily standup meeting to discuss about the issues and solutions.
  • Based the analysis provided what areas the Database need improvements on the performance.
  • Worked on the performance to find out the missing indexes, fragmentation, execution plan, blockings, and deadlocks.
  • Worked on the top 100 Databases, What need to improve before migrating the databases to new datacenter
  • Gather information about the sql agent job information.
  • List out the logins and user information.
  • Developed stored procedures, User Defined Functions, Triggers, Views, Cursors, and CTE’s, T-SQL scripts, schemas, permissions and performance issues.
  • List out the linked server information and details.
  • The servers that I worked on the Bexar County from sql SQL.
  • Provided the summary of the top 100 databases and Report details.

Confidential, San Antonio, TX

Sr. SQL Server DBA

Responsibilities:

  • Working on daily user creating tickets, requests and Problems
  • Monitoring the all the server in Zenoss tool
  • Monitoring replication Monitor and resolving the issues.
  • Participate in Change Management activities.
  • Participate in root cause analysis to support Incident Management issues.
  • Build High Availability database systems for mission critical infrastructure and enterprise applications utilizing shared and non-shared storage solutions such as ALWAYSON and SQL Clustering. Document procedures for repeatable process and efficiency.
  • Troubleshoot performance issues on SQL Servers running on virtual or physical platforms.
  • Deploy maintenance scripts and schedule SQL jobs for database data integrity checks, index maintenance and database backups.
  • Tightened security by modifying service accounts and setting security standards on all SQL Servers. Changed the access methods from user to group based access. Disabled the ‘sa’ account from being used for reporting and other tasks. Switched the SQL service accounts from high privileged domain admin and sysadmin accounts to lower privileged accounts.
  • Provided 24/7 support on call Production Support.
  • Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources
  • Working on Migration project from SQL 2008, SQL SQL.
  • Working on SSRS, security of reports and resolving the issues.
  • Troubleshooting the daily issues from the users like job failure issues, permissions issues, Disk space alerts and query optimization.
  • Configured and implemented the always-on availability on windows failover clustering environment in SQL 2012.
  • Managed Security using SQL Logins, Roles and Security Modes for various users.
  • Used CDC for table replication from DB2 to SQL in migration.
  • DB2 DR plan to implement the CDC replication from on DB2 tables to SQL Database.
  • Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
  • Involved in trouble shooting and fine-tuning of databases for the optimized performance and concurrency.
  • Performed T-SQL performance tuning and Query optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
  • Designed and implemented comprehensive Backup plan and disaster recovery.
  • Analyze execution plans and generate suggestions for improvement.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options. Participated in project meetings for assessment and implementation of new technologies including migration of older systems.
  • Implementation of security patches, updates and service packs and cumulative updates.
  • Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes. prepared maintained and modified SQL server installation and configuration documents
  • Installed all versions of sql on standalone servers and cluster environment servers.
  • Design, Development of T-SQL scripts. Report optimization and Maintenance of DB.
  • Worked on SSRS report migration from and 20008 to 2012 and managed security.
  • Worked with developers to deploy changes through Test and Production environments. Verified scripts before production deployment.

Confidential, Mountlake Terrace, WA

Sr. SQL Server DBA

Responsibilities:

  • Installed SQL 2012 on Test, Production and development environment.
  • Worked on the project to upgrade OS .
  • Migrated the more than 1000 databases from one server to another server.
  • Expert in configuring High Availability concepts like Log shipping, Mirroring, Replication, and Clustering.
  • Worked on the Capacity planning for drives. Acquaintance in supporting Very Large databases (VLDB) and troubleshooting the problems in OLTP Environment.
  • Worked on Idera third party tools like SQL diagnostic manager, SQLSAFE, Compliance manager and Quests Lite Speed Backup Tool.
  • Thorough Understanding of different RAID levels implementation.
  • Designed and implemented comprehensive Backup plan and disaster recovery.
  • Designed and Developed ETL packages to send monthly Data feeds using SSIS.
  • Designed and developed monthly reports for revenue activation using SSRS
  • Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Installed and configured the thresholds in IDERA Diagnostic manager tool on Prod and test Servers.
  • Developed complex programs using T-SQL queries, including Procedures, Triggers, and Functions.
  • Involved in Storage Migration to VMAX Storage Array, played my role in validating the services and testing the drivers for SQL Server.
  • Worked on the performance tuning issues from the users.
  • Enabled the alwayson availability feature in sql instance 2012.
  • Installed SQL Server 2012 on both Standalone and Clustered environments.
  • Worked in a huge clustered Active/Active and Active/Passive Clustered environment.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries. Oversaw unit and system tests and assisted users with acceptance testing.
  • Involved in Scrum meetings to discuss the requirement and support needed for the Production updates.
  • Monitored the Tempdb growth, resized it by adding files in order to increase the performance by parallel process of data storage with in Tempdb, and provided the best practices for TempDB configuration by providing the documentation.
  • Extensively used COSMOS ticketing software for working on RFC is sent by the Database SME’s.
  • Crested custom scripts for monitoring the health of Sql server using DMV’s and DMF’s.
  • Configured and implemented the alwayson availability on windows failover clustering environment in SQL 2012.
  • On a daily basis proactively monitored Error Logs, Sql Servers Logs and Windows Event Viewer for any Unusual errors.
  • Configured clone environment for some of the Production databases for report users as well as Tivoli Storage manager to sweep out the backups.
  • As a part of team member managed over 2000 databases by maintaining the security of data, fixing the failed Principals (logins), user permissions and security in Active Directory.
  • Developed integrated packages to address the issue on client information present across the department.
  • Designed Report Template using SSRS, which addresses the defined business process i.e., “Who gets, what services, from which providers, at which location and when” for further analysis regarding different services.
  • Used Third party tools lite speed in taking up the backups, for compression of the backup files and in setting up Log shipping, Replication.
  • Monitored the daily maintenance, weakly maintenance and monitoring jobs.
  • Worked extensively in maintaining the index fragmentation by regularly scheduling for the reorg/rebuild of indexes based on the fragmentation level and updated the stats.
  • Troubleshooting the daily issues from the users like job failure issues, permissions issues, Disk space alerts and query optimization.
  • Proactively Managed the databases i.e, managed databases, tables, log file allocation and space utilization, identify table growth & file growth for table or index reorganization, fatal errors, failed jobs, integrity violations, performance issues and data abnormalities.
  • Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers from other developers to achieve maximum efficiency and scalability.
  • Provided 24/7 support on call Production Support.

Confidential, Seattle, WA

Sr. SQL Server DBA

Responsibilities:

  • Experienced in AWS (Amazon Web Services) cloud data center.
  • Expert in creating a server, attaching volumes and configure the server settings in AWS environment.
  • Expert in using OPSWISE tool for scheduling windows jobs.
  • Expert in Using Centreon performance tool for monitoring all jobs, space issues, server down.
  • Handled applications on Windows Server 2003 R2 and Server 2008.
  • Open support case with Microsoft to deal with critical issues.
  • Used the Brainstem tool for creating servers, Volumes and Snapshots for volumes.
  • Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers. prepared maintained and modified SQL server installation and configuration documents
  • Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases and mentored Junior DBAs and other technical staff.
  • Setting up and Monitored Database mirroring on Production, QA and Dev servers.
  • Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions
  • Managed Security using SQL Logins, Roles and Security Modes for various users.
  • Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
  • Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
  • Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
  • Analyze execution plans and generate suggestions for improvement.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
  • Handled numerous change management requests on production servers
  • Supported 24 X 7 Production environment

Confidential, Duluth, GA

Sr. SQL Server DBA

Responsibilities:

  • Installation of Teradata 13.10 with ODBC drivers.
  • Expert in security of SSRS and Subscription schedules of RS.
  • Setting security levels for each report and checking monthly reports up to date.
  • Worked both 32 bit and 64bit of ODBC administrator.
  • Experience Connected the SQL server database through SQL assistant from ODBC settings.
  • Worked both Development and production of the Teradata environment.
  • Experience in linked server connection between SQL server and Teradata server.
  • All historical data stored in Teradata database, push the old data from cube to Teradata.
  • Changed the passwords of the Teradata in every 90 days through SQL assistant.
  • Expert in solving issues in BO, SAP (Business Objects).
  • Expert in solving Login issues, requesting new access process, checking security level in BO.
  • Worked both Web intelligence reports and Desk intelligence reports in BO.
  • Worked in BO issues like not retrieving data while running the report, Spool space error, Web page hanging or takes more time running the report.
  • Worked both SQL 2005 and SQL 2008 servers in development and Production environment.
  • Documented the SAP, BO issues and directly worked with the users on the phone to resolve the issues.
  • Successfully carried out the tests to check for suitability of the solution to the user’s requirement in BO.
  • Expert in creating SQL authentication logins and providing different permission to users in different databases.
  • SAP Security & Authorization Implementation-- Role and User Management, Portal Roles
  • Created the backup in maintenance wizard with cleanup historical backups.
  • Based on the maintenance plan created job schedule in SQL server agent.
  • Creating environment variable in production server and Config files.
  • Expert in creating new site collection in SharePoint site in central administration.
  • Adding groups in the SharePoint site in different level of permissions.
  • Deploy the Dev SharePoint site to Prod SharePoint site.
  • Reduce the pending messages in Message queue server BOin both Development and production server.
  • Export or import the data from one instance to another instance using EXPORT/IMPORT wizard.
  • SSIS package deployment from development server to production server in both SQL server and File System Deployment.
  • Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005.
  • Transferred data (ETL) to Data ware house Environment using SSIS
  • Expert in creating Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
  • Successfully deployed reports in various sources like XML, Web Browser and PDF.

Confidential

SQL Developer/DBA

Responsibilities:

  • Installed and configured SQL Server 2005.
  • Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005
  • Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
  • Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
  • Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations.
  • To set up SQL Server configuration settings.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Rebuilding the indexes at regular intervals for better performance.
  • Responsible for Stored Procedures optimization, Performance tuning & index tuning.
  • Provided necessary data validation checks against the data entry.
  • Frequently ran DBCC checks to maintain consistency.
  • Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Hire Now