PROFESSIONAL SUMMARY:

• Microsoft Certified Professional and an accomplished SQL Server Database Administrator with more than 5 plus years of extensive experience.
• Extensive experience in database administration, database architecture and configuration, analysis, tuning, data migration, development and support of SQL Server 2017/2016/ 2014/2012/2008 R2/2008.
• Excellent experience in installation, upgrade, configuration, and administration of SQL Servers in both standalone and clustered environments
• Installed and configured SQL Server and SSIS, SSRS, and SSAS and service packs.
• Performed migration from SQL Server 2014/2012/2008 to SQL .
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database
• Consistency Checks using DBCC Utilities.
• Designed, implemented and managed high availability solutions mainly database mirroring, log shipping, replication, clustering and AlwaysOn Availability groups.
• Solid experience in SQL Server security by controlling permissions and monitoring audit events.
• Managed security and database permissions by creating roles and schema permissions.
• Hands - on experience in creating and monitoring proper alerts for system errors, insufficient resources, fatal database errors, hardware errors.
• Provided daily administration and performance monitoring of Database related systems
• Managed jobs, alerts and schedule using SQL Server Agent.
• Created and reviewed databases and database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Worked with developers on the most efficient database designs and designed database objects.
• Designed and Implemented backup and restore strategy for SQL Server databases.
• Experience in writing and tuning T-SQL (Transact-SQL) (DML/DDL/DCL) Queries
• Experience in SSIS and SSAS to build three-dimensional cube and present the business intelligent data through SQL Server Reporting Services.
• Implemented Table and Index Partitioning to large Databases.
• Supported the database environment of SQL Server databases spanning version as database servers are moved from old version to the new version.
• Excellent experience in data migration between two environments with SSIS packages, backup/restore,
• Experience with detach/attach, import/export wizard, index tuning wizard, Profiler.
• Responsible for overseeing service packs and hot-fixes are uniformly applied to all our environments
• Experience in providing change management support by reviewing, approving, and implementing changes that affect databases
• Supported CRQs, maintenance, deployments on UAT, PreProd,production and development databases 24/7/365.
• Excellent communication skills, self-managing and teamwork spirits in multicultural environment
• Good experience in writing documentation and providing on-call support on a rotation basis

TECHNICAL SKILLS:

Databases: MS SQL Server 2016, 2014, 2012, 2008/R2, 2005, 2000, MS-Access

Programming: Transact SQL, PowerShell, C#, .Net

SQL Server Tools: Management studio, Profiler, Query Analyzer, Import and Export, DTA, SSIS, Replication, Analysis services, Reporting services, & Integration Services.

Operating System: Windows server 2012/2008/2003 Advanced Server, NT & Windows

Third party Tools: Redgate, SQL Litespeed, and spotlight, Nexus, ITSM, ServiceNow, TFS, BitBucket, ARM

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Worked on SQL installation, configuring, upgrades, trouble-shooting performance issues.
• Created backup/Restore plans and refreshing databases from Prod to Dev/UAT and PreProd environments.
• Upgrading SQL from 2008R2 to SQL 2016 and 2017 versions, Implemented new features like Query Stores, Column stored Indexes, InMemory Optimization tables and Data Masking.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS Scheduled and executed SSIS Packages using SQL Server Agent.
• Working closely with customers in testing, Change Management and bug fixing data issues. Creating document for Major changes, priority incidents and providing KT sessions to Team members.
• Worked on OLTP for optimization and to facilitate the processing of large numbers of concurrent updates
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata.
• Created Hyperfind queries to generate reports on Kronos. Involved in in-bound and Out-bound interface with Kronos.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Proposed Kronos upgrade project to Client including SQL server upgrade.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• 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.
• Design,develop and deploying reports using SQL Server Reporting Services (SSRS).
• 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.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

Confidential, Frisco, TX

SQL Server DBA

Responsibilities:

• Used Third Party Tools for monitoring SQL Servers with AutoSys, DNT, Backup with Avamar, NetApp and DDBoost.
• Developed operational policies, procedures, controls and standards and created documentation.
• Develop and maintain implementation guides and maintenance processes and documentation
• Database software s, roadmap planning and maintenance management
• Perform database environment capacity planning and availability management.
• Collaborate with partners to resolve company database policy compliance and vulnerability violations
• Provide 24x7 on-call support for complex production problems to include experience with escalation and communication of the problem to senior management
• Consult with and advise senior management on high impact database solutions and database management topics.Consults extensively with multiple groups to lead initiatives that could have enterprise impact.
• Provide oversight, mentoring, and leadership to less experienced staffand Junior DBAs.
• Lead the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases.
• Consult with and advise senior management and multiple clients on high impact data or database management issues, influencing strategic direction.
• Designing highly complex logical and/or physical databases in SQL Server,leading highly complex data modeling, mapping, integration, and capacity planning efforts;
• Gathering business requirements identification, analysis and development.

Environment: SQL Server 2008, 2008R2, 2012, 2014, 2016, Windows Server 2012, 2008R2, 2008, Clustered, SSIS, SSRS, Management Studio, T-SQL, SQL Profiler, SQL Query Analyzer.

Confidential, Kansas City, MO

SQL Server DBA

Responsibilities:

• Database Administration for SQL Server installations including capacity planning, installation, upgrading, configuration, patching and all functions to provide high availability, high performance and high security.
• Installation and configuration of SQL Server 2014, 2012, 2008, and 2005.
• Installation and configuration of SSIS, SSRS, and SSAS.
• Migration of database from SQL server 2005 and 2008 to SQL Server 2012.
• Implementation of high availably and disaster recovery solutions including clustering, mirroring, log shipping and AlwaysOn availability Groups.
• Performance monitoring, analysis and tuning of relational databases with T-SQL, profiler, tuning advisor, indexes, statistics, and query plan analysis.
• Creation and reviewing of database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Implementing transactional replication and merge replication for high availability of the databases.
• Troubleshooting and resolving database integrity issues.
• Implementing AlwaysOn Availability Groups and the clustered environment.
• Recovering databases from backup in disasters and implementing Point-In-Time Recovery solutions.
• Maintenance plans for backups, history clean up task and rebuilding indexes.
• Engaging in the suggestion and implementation of Backup Strategies.
• Maintaining database security by granting permission to user(s), role(s), and object(s).
• Managing database permissions on securable and objects.
• Administering security for server logins (Windows and SQL Accounts).
• Managing time and priorities in a 24/7 DBA support environment.

Environment: SQL Server 2012, 2014, 2008R2, Windows Server 2012, 2008R2, 2008, Clustered, SSIS, SSRS, Management Studio, T-SQL, SQL Profiler, SQL Query Analyzer.

Confidential

SQL Server DBA

Responsibilities:

• Installing SQL Server 2012 and 2014 in the multi instances environment and service packs.
• Performing and managing database backup and recovery.
• Creating database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Performing clustered and non-clustered index maintenance.
• Creating and monitored job history for maximum availability of data and ensure consistency of the databases.
• Implementing and scheduling Replication process for updating our parallel servers.
• Automating messaging services on server failures for task completion and success.
• Enforcing database Security by managing user privileges and efficient resource management by assigning profiles to users.
• Performing backup and restore of databases.Troubleshooting SQL Server performance issues.
• Creating Database Maintenance plans, SQL Agent jobs, stored procedures and SSIS packages.
• Using database level triggers code for database consistency, integrity and security.
• Migrating data from MYSQL and Oracle to SQL Server using SSMA.

Environment: SQL Server 2012/2014, Windows Server 2012, Performance Monitor, and Backup Utility, DD Boost, Idera, Foglight.