SUMMARY

• 14+ years of Strong working experience as a Senior Database Administrator in SQL Server 2019/ 2017/2016/2 R 2/2008/2005/2000 in Production, UAT, QA, Staging, Disaster Recovery (DR) and Development (Clustered, Stand Alone, VM, Hyper - V and Azure) Environments.
• Experience in architecture, Design, Configure, Implementation, Migration and maintain a highly available infrastructure setup.
• Installing, configuring, monitoring and maintaining SQL Server 2017/2016/2014/2012 , 2008R2, 2008 and 2005 Database Servers in Dev, QA, UAT and Production environments.
• Migrating SQL server Mirroring, Log shipping, Replication and cluster setup environment to SQL Server 2012/2014/2016/2017 with Always on configuration on windows failover cluster.
• Implement setup and maintain Clustering/AAG, Database Mirroring, Log shipping and replication. Perform database backups, recoveries and monitor and react to system-down situations.
• Apply SQL Server software maintenance upgrades and fixes for current and past versions, ability to monitor and react to system-down situations.
• Configuring and setting up of daily database refreshes for ETL and Reporting using T-SQL and SQL Safe, SSIS, SSRS and tools like Solar winds DPA, Idera Compliance Manager, Spotlight, Redgate and Veritas NetBackup.
• Seasoned database administrator with large scale production experience on SQL Server: 1400+ servers, 12K+ databases, 50TB data.
• Strong knowledge of backups restores, recovery models, Capacity planning, database shrink operations, DBCC commands, compressions.
• Experience in troubleshooting and resolving database integrity issues, performance issues, connectivity issues, security issues, blocking and deadlocking issues, mirroring issues, replication issues, log shipping issues and Always-On issues.
• Experience in Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, cursors, transactions, functions, tables, views, rules, defaults, partitioning, triggers, indexes, constraints).
• Expert experience in implementing operational automation using T-SQL, Power shell scripts, VBScript and SQL server agent utility and SSIS (import/ export).
• Expertise in implementing SQL Server security, managing users, granting/revoking access, encryption, TDE, data masking, auditing, and monitoring to comply with Microsoft and industry best practices.
• Coordinate database server maintenance and patching/hot fixes and implement infrastructure changes in accordance with IT Configuration and Change Management policies.
• Performing Production support in 24/7 and on Call duties.
• Preparing Packages, Project Plans, SOX, PCI,Standardized Method of Procedures, Build Sheets, install checklist, Decommission Checklist, Patching Checklist, Upgrades Checklist, Peer review documents, root cause analysis and documentation updates for data load.
• Experience in providing Business Intelligence solutions using SSIS, SSRS, SSAS and Power BI.
• Experience on Snowflake DBA, HVR replication, Tableau, Azure VMs, Azure Data Factory, Azure Data Sync, Storage Accounts, Data Lake, Azure Blob Storage, Azure DWH, security, Geo-replication and Data bricks.
• Extensive involvement in DesigningAzure Resource ManagerTemplate and in designing custom build steps usingPowerShell.
• Designed and developed Cloud Service projects and deployed toWeb Apps, PaaS, and IaaS.
• Configured SQL Server Master Data Services (MDS) in WindowsAzure IaaS.
• Expertise in MicrosoftAzure Cloud Services(PaaS & IaaS), Application Insights, Document DB, Internet of Things (IoT),Azure Monitoring, Key Vault, Visual Studio Online (VSO) and SQL Azure.
• Have interest in designing/crafting efficient modern software’s and learning new technologies/tools if need arises.
• Excellent communication skills, interpersonal skills, and organizational skills.

PROFESSIONAL EXPERIENCE

Confidential, Clearwater, FL

Sr. Database Administrator

Responsibilities:

• Install, configure and maintain appropriate database architecture and systems modules for enterprise-level projects, such as MS SQL Servers 2019/ 2017/2016/2 R2/2008 across Productions, QA, Staging and Development Environments on windows servers 2019/2016/2012 R2/2012/2008R2.
• Configure and implement high availability and disaster recovery procedures in SQL Servers using Always On availability groups, Database mirroring and Database Replication.
• Review and implement MS SQL Cluster (Active/Passive & Active/Active) and Multi Node Cluster using WindowsServerFailover Clustering(WSFC).
• Performance Tuning, Query Optimization using DMV’s, indexing, Performance Monitor, SQL Profiler, Tuning Advisor and other related monitoring and troubleshooting tools such as SolarWinds Ignite, Idera SQL Diagnostic Manager, Spotlight and Redgate.
• Troubleshooting and resolving blocking issues, deadlocking issues, database integrity issues, performance issues, connectivity issues, security issues, mirroring issues, replication issues, log shipping issues and Always-On issues.
• Provide immediate and local technical onsite support for team members, applied expertise in enterprise database management systems tools and technologies.
• Monitor and solve service Tasks, Incidents, Changes and Problem tickets on time which users raise in ticketing tools for support without missing SLA’s.
• Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention utilizing resource monitor, Solar Winds Ignite, Spotlight, Idera.
• Create, tuning, and management of database storage files using SSMS, T-SQL, Disk Management, DMV’s and DMF’s.
• Coordinate database server maintenance, db changes and implement infrastructure changes in accordance with IT Configuration and Change Management policies.
• Implement operational automation using T-SQL, Power shell scripts, Command line (CMD), SQL server agent utility and SSIS (import/ export).
• Implement SQL Server security, managing logins/users, granting/revoking permissions, encryption, TDE, data masking, auditing, and monitoring to comply with Microsoft and industry best practices.
• Prepare Packages, Project Plans, Standardized Method of Procedures, Build Sheets, install checklist, Decommission Checklist, Patching Checklist, Upgrades Checklist, Peer review documents and documentation updates for data load.
• Review and Write complex code while following Microsoft best practices for TSQL coding and optimization (stored procedures, schemas, Cursors, transactions, functions, tables, views, rules, defaults, partitioning, triggers, indexes, constraints).
• Provide Business Intelligence solutions using SSIS, SSRS, Power Bi Report Servers and SSAS in BI tools including development and deployment. Develops database utilities and automated reporting.
• Maintain backups, restores, recovery models, Capacity planning, database shrink operations, DBCC commands, compressions.
• Implement setup, maintain and Migrate SQL server Mirroring, Log shipping, Replication and cluster setup environment to SQL Server with Always on configuration on windows failover cluster.
• Work on SQL Server software maintenance upgrades, patches and fixes for current and past versions, review to monitor and react to system-down situations.
• Configure and set up of daily databases refreshes from production to lower environments using T-SQL, Power Shell, SQL safe and VB Script.
• Create jobs, alerts, log to monitor the database errors with help of SQL server agent utility.
• Evaluate the storage environments for the SQL Server databases, including planning for additional storage, maintaining optimal sizing, monitoring space and providing growth statistics.
• Read query execution plans using estimated, actual, set statistics IO and DBCC show statistics and tune them to improve the system performance.
• Configure Change Data Capture (CDC) using SQL Server Management Studio (SSMS) at database level for all the critical databases to capture the critical changes on the tables.
• Performs database administrator tasks using MS Team Foundation Server, Windows Failover Cluster Manager and SQL Server Configuration Manager.
• Setup and maintain the databases, security and deployments in snowflake Dev, QA, UAT and Production environments.
• Set up and configure the HVR data replication from sql server to snowflake.
• Working experience in setup and managing the loads from SQL server to LZ, ODS and EDW and integration to Tableau.
• Setup and configure the IIS, Tableau bridge and deploy the reports to UAT and PD environments. setting up the data loads from BYOD to on-premises databases using Azure data factory and data sync.
• Support the Data migration activitiestowards the D365 integration project.
• Create and automate the data loads using JAMS jobs.
• Deploy the SSRS and power BI reports using azure devops via VS.
• Set up and configure the azure VM’s, azure sql servers, azure databases, firewalls and security.
• Set up and configure the power BI report servers on always-on (AAG).
• In-place/side by side upgrades from /2019 and setup DB server’s alias usage.
• Transfer the files using AWS S3 bucket for third party sites.
• Downgrade the lower environment servers from enterprise to developer and decommission to save the licensing costs based on customer needs and evaluation.
• Migration of DB’s from On-premises to Azure cloud and setup the required security and open the ports from the client machines.
• Designed and developed Cloud Service projects and deployed toWeb Apps, PaaS, and IaaS.
• Configured SQL Server Master Data Services (MDS) in WindowsAzure IaaS.
• Implementing MicrosoftAzure Cloud Services(PaaS & IaaS), Application Insights, Document DB, Internet of Things (IoT),Azure Monitoring, Key Vault, Visual Studio Online (VSO) and SQL Azure.
• Implementing High availability with Azure classic and azure resource manager deployment models.

Environment: MS SQL Server 2019/ 2017/2016/2 R2/2008, SQL, TSQL, SQL Safe, Windows 2019/2016/2012 R2/2012/2008R2, SQL Profiler, Business Intelligent technologies SSIS, SSRS, SSAS, Power BI, SQL server agent utility, Solar Winds Ignite, Spotlight, Redgate, Idera, SQL Server Management Studio (SSMS), Tuning Advisor, SQL Server Configuration Manager, Mirroring, Log shipping, Replication, Always on, WindowsServerFailover Clustering(WSFC), DMV’s, DMF’s, MS Team Foundation Server, Change data capture (CDC), Windows Failover Cluster Manager, snowflake, resource monitor, Power Shell, Command line (CMD), DBCC, Microsoft Azure, Tableau, Microsoft D365

Confidential, Saint Louis, MO

Senior Database Administrator - SQL

Responsibilities:

• Performs technical and functional requirements analysis, effort estimation, and resource planning to determine feasibility of proposed business solutions.
• Implements on operational automation using T-SQL, Power shell scripts, VBScript, SQL server agent utility and SSIS (import/ export).
• Detects and troubleshoots SQL Server related CPU, memory, I/O, disk space, and other resource contention.
• Seasoned database administrator with large scale production experience on SQL Server: 1400+ servers, 12K+ databases, 50TB data.
• Prepares the SOX/PCIAuditing Reports on SQL based servers on Monthly/Quarterly basis and get them approved with the higher management team after the remediations are in place.
• Migrating SQL server Mirroring, Log shipping, Replication, and cluster setup environment to SQL Server 2012/2014/2016 with Always on configuration on windows failover cluster.
• Installs, configures and maintains appropriate database architecture and systems modules for enterprise-level projects, such as MS SQL Servers across Productions, QA, Staging and Development Environments.
• Configures and implements high availability and disaster recovery procedures in SQL Servers using Always-On and Database Replication.
• Reviews and implements MS SQL Cluster (Active/Passive & Active/Active) and Multi Node Cluster.
• Performs Tuning, Query Optimization, Database Mirroring configuration and other related troubleshooting support, including resolving database integrity issues, performance issues, connectivity issues, security issues, blocking issues & deadlocking issues, mirroring issues, replication issues, log shipping issues and Always-on issues.
• Provides immediate and local technical onsite support for team members, applied expertise in enterprise database management systems tools and technologies.
• Identifying the data sources to be migrated and document everything for future use.
• Provides recommendation for system improvements and possible solutions to support and maintains standards for quality assurance compliance. Coordinates changes to database and implement security measures as required. Develops and maintains proficiency in a range of database management technical and analytical tools as defined by company standards.
• Employs effective communication techniques to collaborate with and provides project test and status reports to team members, direct supervisors, and responsible managers, and to develop accurate documentation that complies with company standards.
• Providing 24/7 on call support for production databases.
• Monitoring and solving tickets on time which users raise in Service Now tool for support without missing SLA’s.
• Space management of SQL databases and Generate a growth trend report on storage to be added by following up with the application team on a GLID to be processed to avoid the outages where it is necessary.
• Experience in configuring and managing Linked Servers for data transfer between SQL Server and other heterogeneous relational databases such as Oracle, MySQL, Teradata, Sybase, and DB2.
• Preparing Packages, Project Plans, Standardized Method of Procedures, Build Sheets, install checklist, Decommission Checklist, Patching Checklist, Upgrades Checklist, Peer review documents and documentation updates for data load.
• Managing Security related tasks such as Creating users, AD Groups, logins, roles and granting permissions on daily basis.
• Transferring the files/backups from SQL to other vendor sites using WINSCP FTP conversion.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Used SQL Profiler and PERFMON to monitor and resolve deadlocks and long running queries.
• Performed in identifying the sub-optimal solution for code in production server with SQL Trace.
• Running the Go Home scripts to send back to home nodes after patching.
• Adding new instances into respective Ignite tool for monitoring/troubleshooting purpose.
• Deleting the shadow copies on drives to release space to data/log drives.
• Creating jobs, alerts, log to monitor the database errors.
• Analyzing the requirements to migrate to SQL-Server from different sources like Oracle, MySQL.
• Troubleshooting and documenting root cause analysis.
• Experienced in Installation, Maintenance and Troubleshooting on Windows Server, Active Directory, Domain Controller, DNS, DHCP, WINS, Cluster Administration, and User accounts, Security Policies, Security Issues.
• Working in Data Encryption and Data Decryption for data security in Database & Column level.
• Implemented the new SQL Server mechanisms like data compressions, online indexing, Contained Databases and security principals.
• Follow the change management process to move database changes into production.
• Writing the procedures, triggers in T-SQL.
• Planned & executed of any upgrade such as Service Pack, Hot fixes, and patching.
• Working with the fire wall team to open the ports between the instances to stabling the linked server’s between different domains (CHTR, TWC &BHN) and access purpose.
• Implementing indexes such as clustered index, non-clustered index on data structures to achieve faster data retrieval.
• Migrating the number of reports using Report Sync utility and mapping the correct data sources and creating the Data Sources when needed.
• Migrating the SSIS packages to Production/UAT, which users raise in ServiceNow with change management process.
• Creation of database maintenance plans, rebuild/Reorganize indexes, audits, update statistics, encryptions and decryptions.
• SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, Cursors, transactions, functions, tables, views, rules, defaults, partitioning, triggers, indexes, constraints)
• Performing the backups, restores, recovery models, Capacity planning, database shrink operations, DBCC commands. Can plan effective backup strategy as per the environment needs.
• Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler, Ignite, Idera, Splunk, Solar Winds, NetIQ Console and other related monitoring and troubleshooting tools.
• Implemented high availability withAzure ClassicandAzure Resource Managerdeployment models.
• Created, deployed and managed reports usingSQLServerReporting Services (SSRS).
• Experience in “migrating” on premise workloads to the cloud.
• Developed methodologies for cloud migration, implemented best practices and helped to develop backup and recovery techniques for applications and database on virtualization platform.
• Extensive work experience in tempdb configuration, table partitioning, shrinking, link server, compression, and database optimization.
• Set up and maintain database environments to support production, QA, development and UAT activities and ensured the Availability of the Database Server in a 24X7 Environment.
• Migration of Data from different sources like Excel, Flat file, DB2, Sybase, Oracle, MySQL to MS SQL Server by using SQL Server Integration Services (SSIS), BCP, Bulk Insert and DTS(Export/Import) utility.
• Worked with Back up teams, monitoring teams and windows teams for Decommissioning the instances and alert set up for new instances.
• Automated the refresh scripts from prod to UAT to Dev for testing purposes.
• Prepared the technical documents for replication, back up jobs (net and native backups), SQL Job agent jobs, other maintenance jobs for future reference.
• Updated the Passwords in password safe tool for reference and access purpose for other team members to perform the DBA activities.

Environment: MSSQLServer 2019/ 2017/2016/2 R 2/2008/2005/2000 , MS Access, Oracle 9i/10g/11g/12c,MySQL,teradata, Windows 2012R2/2012/2008R2/2003,SQL, TSQL, PL/SQL, RedGate, ERWIN,SQLProfiler, UNIX Putty, ITIL, Business Intelligent technologies SSIS, SSRS, SSAS, Power BI, Microsoft Azure, AWS, RedShift, Charter Service Now, SQL Server Migration Assistant(SSMA), Service Desk, Remedy, ESarf, ESD, HA/DR, Ola Hallengren's SQL Server Maintenance Solution, Precise, Ignite, Idera, Splunk, Solar Winds, NetIQ Console, SQL Plus, SQL Server Management Studio, MS Visio, Performance monitor, Veritas NetBackup, resource Monitor, Services, Event Viewer, Tuning Advisor, Index Tuning Wizard, SQL Query Analyzer, Index Analyzer, Dbatools, Python, Perl, Linux, SQL Server Configuration Manager, Report Sync utility, Agile, Microsoft Visual Studio, SQL safe, SQL DM, Windows Failover Cluster Manager, Password Safe and WINSCP.

Confidential, Greenville, SC

Lead Database Administrator

Responsibilities:

• Installation, configuration, maintenance, troubleshooting, design, development, management and support of MSSQLServers 2016/2014/2012/2008 R 2/2008/2005/2000 in Production, UAT, QA, staging and Development Environments.
• Actively involved in upgrading (Side-by-Side and In - Place) versions fromSQLServer, 2008R2 to 2012 and .
• Installed necessary Service Packs forSQLserver2005/2008R 2/2012/2014.
• Seasoned database administrator with large scale production experience on SQL Server: 2250 servers, 32K+ databases, 80TB data.
• Experience on data transfer from and to target SQL server application usingSQLServer Integration Services (SSIS), BCP, Back Office/Cransoft technologies, bulk insert, Import/Export Wizard, Linked Servers, and DTS utility.
• Managing security and administering the MSSQLserverby creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the Privileges to Users and Groups.
• Experience in configuring Database Mirroring (High safety and High performance) and ensuring high Availability to the databases by testing the failover.
• Created Database Maintenance Plans and Involved in Data/Table partitioning, online Indexing, rebuild/reorg indexes, DBCC checks and Update statistics at regular intervals for better performance.
• Implemented Log Shipping as a Disaster Recovery option, MSSQL Mail, and SMTP.
• Database backups, restores, capacity planning, recovery models (simple, full, bulk-logged), check points, DB Shrink operations, detach, attach, copy database wizard, generate scripts wizard, publish database wizard, backup strategies as per environment needs and scheduling backups.
• Extensively worked on Active-Active, Active-Passive two node Clustering and three node clustering (Active-Active-passive).
• Creating and managing schema objects such as tables, rules, defaults, views, indexes, procedures, Cursors, transactions, triggers, constraints, partitioning and functions.
• Creating and Managing Audits with Transact-SQL and SQL server Management studio.
• Created different types of encryptions and decryptions inSQLServeras per the client requirement to secure the data and also use it in flexible ways by a group of users.
• Configured and implemented High availability and disaster recovery in SQL Servers using Always-On (Synchronous-commit, Asynchronous-commit) and Database Replication (Snapshot, transactional and Merge).
• Expert experience in implementing operational automation using T-SQL, Power shell scripts, SQL server agent utility and SSIS (import/ export).
• Experience in troubleshooting and resolving database integrity issues, performance issues, connectivity issues, security issues, blocking and deadlocking issues, mirroring issues, replication issues, log shipping issues and Always-On issues on regular basis.
• Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages.
• Knowledge of Data modeling including Physical and logical data modeling using ERWIN, VISIO.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, DMVs, DMFs, SQL Profiler and other related monitoring & troubleshooting tools.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Perform recovery of the databases, import table’s schema as requested.
• Set up and maintain database environments to support production, QA, development and UAT activities and ensured the Availability of the Database Server in a 24X7 Environment.
• Monitoring and solving tickets on time which users raise in Confidential tool for support without missing SLA’s. identify data sources, construct data decomposition diagrams and provide data flow diagrams to document for the customer needs.
• Write/Automate the code/scripts for database access, modifications and constructions.
• Expert in usage of System/User-Defined Data types, Transact-SQL Functions, System procedures, dbcc stored procedures and global Variables.
• Providing 24/7 on Call Support for Production Databases.
• Migrating SSIS packages into Production after lower environments successful deployment.
• Involved in Creating jobs, alerts, log to monitor the database errors.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc depends on scenarios.
• Knowledge on developing and deploying OLAP cubes through SSAS.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created, deployed and managed reports usingSQLServerReporting Services (SSRS).
• Job Monitoring and making sure all jobs ran successfully every day.

Environment: MSSQLServer 2016/2014/2012/2008 R 2/2008/2005/2000 , MS Access, Oracle 9i/11g, Sybase 16.0/15.7, MySQL, Teradata, Windows 2012R2/2012/2008R2/2003, SQL, TSQL, PL/SQL, ERWIN,SQLProfiler, UNIX Putty, AWS, RedShift, ITIL, SQL Server Migration Assistant(SSMA), Business Intelligent technologies SSIS, SSRS, SSAS, HA/DR, Confidential Service Now, Sqldbx, SCOM, WIN ISQL, SQL Developer, Splunk, SQL Plus, SQL Server Management Studio, Idera, Ignite, MS Visio, Tuning Advisor, Index Tuning Wizard, SQL Query Analyzer, Index Analyzer, Linux, Python, Perl, SQL Server Configuration Manager, Microsoft Visual Studio and Back Office/Cransoft technologies.

Confidential, Schenectady, NY

Senior SQL Server DBA

Responsibilities:

• Installation, maintenance, troubleshooting, development and support of MSSQLServers 2012/2008R2/2008/2005 in production, UAT, QA, staging and development environments.
• Used SSIS/BCP/DTS/Back office/bulk insert and DTS utility to Export/Import data from different legacy source systems to target SQL server application.
• CreatedServerLogins, Database users, unlockedSQLUser accounts, and Password resets and Granted users and groups to Default/Custom roles and performed security password changes on quarterly basis as per the business requirement.
• Expert in Performance Tuning, Query Optimization, client/serverconnectivity, blocking, deadlocks and database consistency checks using DBCC commands, DMV’s, DMF’s, performance monitor and profiler.
• Clustered and non-clustered index creation/optimization usingSQLProfiler and Index Tuning Wizard. identify data sources, construct data decomposition diagrams and provide data flow diagrams to document for the customer needs.
• Created Database Maintenance Plans for Database Integrity Checks, shrink database, Rebuild /Reorganize Index, Update Statistics, History Cleanup task, Execute SQL Server Agent Job, Maintenance Cleanup task and backups.
• Design and normalize the databases and created different objects such as tables, views, rules, defaults, functions, triggers, stored Procedures, Production Code Deployment and handling concurrent user requests.
• Setup/automate internal processing tasks and backup tasks as well as setting up alerts to monitor theserverand database health UsingSQLserver Agent utility.
• Experience in Side by Side upgrades and in place upgrades using upgrade advisor fromSQLServer2005 to SQLServer2008/2012, troubleshoot performance issues, upgradation issues and transfer logins to instance.
• Setup Database Mirroring on multipleserverswith High Availability automatic failover for Hot Standby.
• Creating and Managing Audits with Transact-SQL and SQL server Management studio.
• Worked in Active-Active, Active-Passive for maintaining High availability solution by Clustering.
• Created different types of encryptions (s) and decryptions inSQLServeras per the client requirement to secure the data and also use it in flexible ways by a group of users.
• Good experience in implementing replication with snapshot and transactional as per business requirements.
• Write/Automate the code/scripts for database access, modifications, and constructions.
• Worked on Migration of packages from DTS usingSQLServerIntegration Service (SSIS).
• Created High Availability with Always on Availability Group on MSSQLServer2012.
• Experience in configuring and managing Linked Servers for data transfer between SQL Server and other heterogeneous relational databases such as Oracle, Sybase and DB2.
• Configured Log shipping from Production to Disaster Recoveryserveras part of the disaster recovery plan.
• Involved in various stages like development, Testing and Support for different application teams.
• Support for ongoing database issues which users raised in Confidential tool without missing SLA’s.
• Created and maintained technical documentation for future reference.
• Provided 24/7 DBA Support on weekly basis within the team.

Environment: MSSQLServer2012/2008R2/2008/2005, SQL, TSQL, PL/SQL,Oracle 9i/11g,Sybase 15.7/15.5, MySQL, Teradata, BI Tools SQLServerIntegration Services (SSIS),SQLServerReporting Services (SSRS),SQLServerAnalysis Services (SSAS),SQLServerManagement Studio, MS Excel, Windows 2012/2008R2/2003, ERWIN,SQLProfiler, ITIL, Linux, UNIX Putty, Confidential Service Now, Sqldbx, WIN ISQL, SQL Developer, SQL Plus, SCOM, Idera, Ignite, MS Visio, SQL Server Migration, Python, Perl, Assistant(SSMA),Microsoft Visual Studio, HA/DR, Tuning Advisor, Index Tuning Wizard and Back Office/Cransoft technologies.

Confidential

SQL Server DBA

Responsibilities:

• Installed, configured, development and support of MS SQL Server (2000, 2005, 2008, 2008R2 and 2012) in production, development, UAT and QA environments.
• Migrate/upgrade oflower SQL to latest SQL Server Editions -2005/2008R2.
• Created logins, groups, users, roles, and implemented SQL Server security policy.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags, SQLProfiler and activity monitor.
• Checked Database Health by using DBCC Commands, DMV’s and DMF’s.
• Configuring and administering Database Mirroring, Log Shipping.
• Experience in migration of Data from different sources like Excel, Flat file, DB2, Sybase, Oracle, MySQL to MS SQL Server by using SQL Server Integration Services (SSIS), BCP, Back Office/Cransoft technologies, Bulk Insert, Linked servers and DTS(Export/Import) utility.
• Expert experience in implementing operational automation using T-SQL, Power shell scripts and SQL server agent utility.
• Creation of database maintenance plans such as rebuild/Reorganize indexes, update statistics, Database Integrity Checks, shrink database and backups.
• Involved in Production releases and Coordinating with developers to move database changes into production. identify data sources, construct data decomposition diagrams and provide data flow diagrams to document for the customer needs.
• Identifying the daily SQL server agent jobs failure, trouble shoot and fixing.
• Conducted code reviews adding/changing tables for data loads, data extraction and documented a tested program code for future use.
• Write/Automate the code/scripts for database access, modifications and constructions.
• Monitoring and solving tickets on time which users raise in Confidential tool for support.
• Maintains database objects such as tables, views, indexes, partitioning, stored procedures, triggers, constraints based on analysis of application requirements.
• Space management of SQL databases and Generate a growth trend report on storage to be added by following up with the application team on a GLID to be processed to avoid the outages where it is necessary.
• Supporting 24/7 on call production support on rotation basis.
• Created SSIS packages and deployed packages, configured job automations and migrated the packages.

Environment: MS SQLServer2012/2008R 2/2008/2005/2000 , SQL, T-SQL, MS Access, PL/SQL, MS Excel, Business Intelligent technologies SSIS, SSRS, SSAS, ITIL, Windows 2008R2/2008/2003, Python, Perl, ERWIN,SQLProfiler, Oracle 9i/11g, Sybase 12.5/15.0, MySQL, Teradata, UNIX Putty, HPSD, Confidential Service Now, Sqldbx, WIN ISQL, SQL Developer, SQL Plus, Linux, SQL Server Management Studio, Idera, Ignite, MS Visio, SQL Server Migration Assistant(SSMA),Microsoft Visual Studio and Back Office/Cransoft technologies.