EXPERIENCE SUMMARY:

Highly motivated SQL Server Database Administrator (DBA) with over 7 (Seven) years of experience effectively planning, installing, configuring and optimizing SQL Server 2016/2 databases in enterprise environments. I have been supporting mirrored and clustered environments, high - availability and disaster recovery, database security, database monitoring and performance tuning, patch management, change management and providing 24x7 production support.

PROFESSIONAL SUMMARY:

• Expertise in MSSQL Server Database Administration, installation, configuration, monitoring and maintenance with effectively finding and troubleshooting root caused capabilities in both Cluster and Standalone environment
• Proven experience in the areas of Database Performance Tuning using SQL Server Profiler, Execution Plan, PerfMon, Activity Monitor, DMV, DBCC, Extended Events, Database tuning Advisor (DTA) and Policy Based Management
• Strong work experience and knowledge with High availability (HA) solution using Replication, Database Mirroring, Clustering, Log shipping, Always-On Availability - includes Installation, Configuration and Administration
• Experienced in upgrading SQL Server (2000/2005/2008/2008 R2) instances to SQL Server 2012/2014/2016 and migrating (databases) from Oracle, MySQL, MS Access to SQL Server
• Strong knowledge and experience in capacity planning and implementing disaster recovery solutions- database Backup, Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines
• Experience in applying service Pack (SP) and Hot Fixes in Standalone, Mirrored and Clustered environment
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization, E-R diagram and building Referential Integrity Constraints, Operating Systems (Windows server 2003/2008R2/2012R2), AD (Active Directory)
• Excellent T-SQL skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, Temp table, Table variable, Synonyms, CTE etc. and knowledge on HTML, SQLCMD and PowerShell
• Experience on creating and troubleshooting of SQL Server Agent Jobs, Scheduling and set up Alerts and Notification and Database Mail and Proxy Account
• Extensive work experience in Table Partition, Backup Compression, Performance Optimization of Database and server, query Optimization
• Implement Linked Servers configuration within SQL Servers & Other Database platforms, maintain & troubleshoot SQL Server Security
• Experience on troubleshooting locking, blocking and dead locking, log file growth, jobs, server and database related issues
• Solid experience in SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Experience in ETL processes, developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert
• Extensive work experience in creating and deploying SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, union all etc.
• Hands on experience on configuring and managing SQL server instances in Azure Environment
• Knowledge and Experience on Third party Tools: IDERA 9.0 and 10.1, Apex, JIRA, TSM and TDP (for backup and recovery)
• Experience on using Smart IT(BMC) for version controlling and internal ticketing, System Center Operation Manager (SCOM) for server monitoring
• Strong knowledge on Domain Controller, Group Policy Management on Windows Server 2008 R2/2012 R2, VMware, Hyper-V, VPN Server, FTP Server and IIS Web Server and storage systems RAID level (ISCSI and SAN)
• Excellent Team player, detailed oriented, strong analytical and problem-solving skills and managing large OLTP and OLAP Databases in 24X7 in Production, Test and Development environment

EXPERIENCE:

Confidential, Dearborn, MI

SQL Server DBA/Database Administrator

Responsibilities:

• Installing, configuring and managing SQL Server 2014, 2012, 2008/R2 in development, testing and production environment
• Installing and configuring SQL Server 2016 SP1(1 click installation).
• Creating and implementing backup strategy in the event of disaster
• Experience in Point-in-Time recovery
• Refreshing database in test and development environment
• Troubleshooting TSM and TDP backup issue
• Implementing active/passive cluster on 2016/2014 to achieve High-Availability
• Configuring and maintaining database Mirroring including automatic fail-over option in SQL Server 2016/2014
• Implementing database snapshot to use mirror database for reporting purposes
• Configuring Log Shipping for datacenter support
• Configuring and maintaining Transactional Replication (Attunity Tool)
• Configuring and supporting Always On in production environment SQL Server 2016/2014/2012 (Based on clients need)
• Maintaining Troubleshooting security issues
• Creating database and application role when necessary
• Using Logon triggers for security auditing
• Creating and managing proxy account
• Implementing FORD process PAR, GGM and PEN
• SQL Server 2008/R2 to 2012
• SQL Server 2012 to SQL Server 2016 SP1-CU8
• MS Access 2013/2007 databases into MS SQL Server 2016
• Oracle 10gR2/11gR2 databases to SQL Server 2016
• Share Point Migration 2014/2016
• Applying SP on cluster environment as well as standalone environment
• Creating and maintaining documentation on SP
• Applying hot fixes and CU
• Managing changes including all development related works using BMC change control/GICC systems
• Maintaining internal work items using Request Center/BMC Incident
• Using Gurdium Wrapper before script execution in Production
• Suggesting developing team in case of failure
• Applying in testing server before implementing in to production server
• Monitoring database performance using SQL Server native tool such as PerfMon, Profiler, DTA, Activity Monitor, DBCC, Execution Plan, DMV
• Implementing SCOM to automate different activities such as monitoring database health, disk space, job alert, index maintenance, statistics maintenance
• Monitoring real-time activities on server using SCOM
• Troubleshooting locking, blocking and deadlocks
• Troubleshooting slow running queries or stored procedure
• Using DBCC to check database conditions, fix database corruption, rebuild indexes and database maintenance
• Using DMV to find current activities on the server
• Installing, configuring and administering SQL Server Reporting Services (SSRS)
• Developing DBA Reports for reporting
• Developing server performance report using SCOM and PerfMon
• Creating, deploying and managing SSIS Package
• Uploading and moving data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server using export/import and SSIS
• For large amount of data implemented BCP/bulk insert
• Login and job transfer during upgradation
• T-SQL, Trigger, Functions, Join, Stored-Procedures
• Assisting Database Developers to optimize SQL queries and Store Procedures
• Job creation and troubleshooting job failure
• Alerts setup
• SSIS package job creation
• Implementing maintenance plan
• Proxy account

Environment: Windows Server 2016/2012R2/2008R2/2003R2, IIS 8, 7.5, 6.5, SQL Server 2016/2 R2, ASP, ASP.net, PHP, AD (Active Directory), SCOM, TSM, TDP, visual Studio 2015. PowerShell V5, Data Tools, SSMA

Confidential, Pearl River, NY

SQL Server DBA/Database Administrator

Responsibilities:

• Monitored and maintained large scale (1000+) databases and 45+ SQL Servers
• Maintained mix of standalone and clustered SQL instances
• Planned, performed, and monitored database backups
• Assisted users with database troubleshooting
• Installed and upgraded database software
• Standardized the implementation of databases and improved management of DAU production and test environments
• Supported users by resolving problems with applications
• Worked professionally in a team-oriented environment
• Installed, configured and administered of SQL Server 2005 & 2008R2 & 2012
• Supported application developers in designing and implementing physical database structures
• Implemented stored procedure to audit SQL servers; established and enforced security auditing mechanism, performance tuning and optimization
• Researched, designed and tested a migration plan from SQL Server 2005 to SQL Server 2012
• Designed DR database backup and restore plan
• SQL Server performance statistics collection, server monitoring and performance tuning
• Managed user accounts and connection troubleshooting
• Worked on database capacity planning, maintenance planning, SQL Agent Jobs scheduling and troubleshooting
• Implemented and maintained database security, replication, Standby server, DTS, log shipping, SQL Mail Manage small, medium and large SQL Server 2000 projects
• Experienced in writing SQL queries, Stored Procedures, Triggers, and Functions, creating Tables, Views and Indexes
• Involved in installing, configuration and administration of SQL Server 2012
• Researched, designed and tested a migration plan from SQL Server 2008 R2 to SQL Server 2012
• Promoted/migrated SQL-Server objects from development to QA and QA to production instances
• Working experience on data modeling projects from end to end including generating scripts for objects, Develop Relationship, and Creates E-R Diagram
• Creating and managing Object, Schema, Indexes, Constraints

Environment: Windows Server 2012, 2008 R2, 2003 R2, 2000, IIS 6.0, SQL Server 2012,2008R2,2005, 2000, ASP, PHP, IDERA, AD (Active Directory), Internal (Registration System, Reporting System) and third-party applications (Time Sheet, Payroll, HR)

Confidential, Columbus, OH

SQL Server DBA/Database Administrator

Responsibilities:

• Upgraded SQL Server 2000 to SQL Server 2008R2
• Implemented Side-by-side Migration of databases from SQL Server 2000/ R2
• Developed stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction
• Integration of various data sources such as SQL Server and using written stored procedures in Data Stage jobs
• Worked on Client/Server tools such as SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server, performance testing on stored procedures, indexes, and triggers
• Created DTS Packages for data import, export, scrubbing and scheduled jobs for backups
• Implemented data migration using bulk copy program and DTS
• Assisted front-end application developers with their queries
• Monitored scheduled jobs to make sure all jobs run smoothly
• Performed low-level scripting, fixing of codes and software enhancement process
• Performed ad hoc administrator tasks such as managing users, roles, and profiles
• Performed Database backups with application tools, for instance, lite speed
• Implemented SSRS to generate all daily, weekly, monthly and quarterly Reports including status
• Developed various reports and reporting interfaces utilizing Microsoft SQL Reporting Services
• Recommended Replication techniques to meet business needs
• Setting MAX DOP (Max Degree of Parallelism) to 8 for 28 GB memory
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation
• Analyzed execution plans, tuned queries and databases for better optimal performance
• Fixed missing indexes and excess indexes
• Generated script files when changes applied to stored procedures and functions
• Managed schema objects such as, Triggers, cursors, indexes, procedures

Environment: SQL Server 2000/ /2008 R2Enterprise, MySQL, Windows Enterprise Server 2003/2005, IIS 6.0, T-SQL, Microsoft Reporting Service