SQL DBA

Syed

Email : **********.***@*****.***

Cell : +1-609-***-****

SUMMARY:

* ***** ** ** ********** in Database Administration, Design Development and Support of MS SQL Server 2016/2014/2012/2008R2/2008 in Production, Test, Development and Cluster Server Environments.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2008R2/2012/2014/2016.

Experience in Disaster Recovery Planning, Execution and Testing at remote side.

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008, MS SQL Server 2008R2 to 2012, MS SQL Server 2012 to 2014.

Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.

MDX development/conversions (Excel Business Functions)

Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission).

Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.

Experience in implementing high availability using Log shipping, and Database mirroring in SQL Server 2008R2/2012/2014/2016

Extensive experience with IIS (Internet Information Services) 5.0/6.0.

Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).

Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.

Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

RELATED TECHNICAL SKILLS

ANALYSIS /METHODOLOGIES

UML, Agile methodology, Waterfall methodology, Cost/Benefit Analysis, Gap Analysis, Feasibility Analysis

PROGRAMMING & WEB LANGUAGES

C,C++, HTML

MICROSOFT TOOLS

MS office Suite (Word, Excel, PowerPoint, Access), Adobe Acrobat Reader, MS SharePoint, MS visual Studio

RATIONAL SUITE

Rational RequisitePro, Rational Rose

REPORTING

MS Excel

DATABASE

MS SQL Server 2008R2/2012/2014/2016

OPERATING SYSTEMS

Win 95/98/NT/2000/XP, Mac OS, Unix

PROFESSIONAL EXPERIENCE

Fifth Third Bank Feb 2016 – Present

SQL Server Database Administrator/ AWS Cloud Support Associate Cincinnati, OH

Responsibilities:

Work collaboratively with development, QA, server, and support teams, both on-site and offshore, throughout the SDLC. Supporting Production, Development and Testing Environments for multiple clients.

Configuring high availability solutions (Log shipping, Database Mirroring, Replication) and monitoring.

Work with database code to ensure that database best practices are adhered to while meeting the business driven functionality requirements of the application.

Took ownership of the database environments by proactively monitoring SQL Server system performance in development, QA, staging, stress test, and production environments. Manage resource utilization of SQL Server resources. Troubleshoot issues that fall outside normal performance metrics.

Install SQL Server instances configure appropriate high availability options. Configure new servers to have required maintenance jobs installed and ensure proper monitoring of server performance. Maintain disaster recover environment.

Conversant and thorough with Microsoft SQL Server 2008 R2, internal architecture and behavior of SQL Server features

Design and build complex transactional databases and data warehouses. Write, tune, and troubleshoot using TSQL. Manage production SQL Server instances in high volume mission critical transactional environments.

Administration and troubleshooting on a high availability SQL Server environment in administration of mission critical, enterprise wide clustered SQL Server instances. Monitoring and Troubleshooting Cluster servers (Active/Active, Active/Passive).

Running imports/export utilities, off-line backup, on-line backup various SQL server Applications utilities.

Work on DTS, Import and Export utility, BCP Utility and replication tool.

Troubleshoot security issues. Grant privileges to users to access systems and databases. Establish connectivity to databases and monitoring system performance.

Use Enterprise Manager and Query Analyzer to optimize the data flow; setup standby server, DR servers and monitoring them. Troubleshoot performance issues using DMV’s, Profiler and Perfmon.

Perform Index tuning, Query tuning and application tuning. Performance Monitoring, estimate the number of users, CPU and Disk space requirement, identifying bottleneck and rectifying it, fine-tuned store procedures to improve performance, database loads performance improvements, proper setup of database files and file groups to boost performance.

Provided technical assistance for enterprise solutions and cloud services.

Participated in migration of cloud clients within data centers.

Maintained email accounts, VPN user details and change requests.

Analyzed and resolved issues relating to PeopleSoft applications.

Created and updated user IDs and security group tasks.

Participated in administration of client accounts with cloud services.

Provided technical assistance for all cloud operations.

Environment: SQL Server 2008R2, SQL Server 2012, SQL Server 2014, SQL Server, 2016, SSIS, SSRS, & SSAS, windows server 2000, 2008, 2008 R2, Lotus, Remedy, Patrol Agent.

Sherwin Williams - Cleveland, OH Mar 2015 - Jan 2016

SQL Server DBA

Responsibilities:

Migration of databases from SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to 2014 & SQL Server 2014 to 2016. Setting up new SQL Servers and configure required users. Restoring and copying production databases.

Installation and configuration of MS SQL Server 2008R2/2012/2014/2016 on new production and Test Servers with latest Security updates involving Service Packs and cumulative updates.

Used new features like row and page compression mechanism, Data Compression, and Backup compression.

Configured File Stream in SQL Server 2012/2014/2016 to manage BLOB’s effectively.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Created Tables, Views, Dynamic Stored Procedures, User Defined Functions, Transact-SQL statements and other advanced queries for databases by using Query Analyzer and SQL Server Management Studio.

Developed, modified, and optimized complex queries to data retrieval and modification.

Monitored database status including CPU, Memory, I/O, space and Dead Lock using SQL Server Utilities

Installed, configured and maintained MS SQL Server Replication for production servers to provide High Availability.

Successfully implemented Database mirroring on SQL 2008R2/2012/2014/2016 Servers for Disaster Recovery and monitor databases involved in mirroring sessions.

Performed Database Backups for Production, Test and Development Servers and restored backups onto test servers to ensure that we had good backups.

Creating stored procedures, scripts, cursors for the Bulk application, testing on the test servers and moving them to production

Managed Capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, disaster recovery, database consistency check, rebuild indexes, and update statistics.

Involved in upgrading of SSIS Packages from SQL Server 2012 to SSIS packages in SQL Server 2014 database.

Creating new SQL Server Azure Cloud Services subscriptions.

Creating Database(s) on SQL AZURE.

Created & managed SQL Server AZURE Databases.

Creating New Storage Account, selecting Disk Types, configurations and attaching them to Servers.

Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.

Expertise in using DBCC trace flags, handling blocking and dead lock situations.

Deployed the created SSIS packages in Development and Testing environments.

Created and developed the Stored Procedures to handle complex business rules, history data and audit analysis.

Designed/Implemented the SQL Reporting Services Management Security.

Designed and generated simple, custom and complex reports against the new cube using SQL Server Reporting Services (SSRS) 2012

Data migration using SSIS 2012/2014/2016 across different databases and Flat Files.

Used tools like SQL safe for compressed backups and easy to restore, Red gate for multipurpose usage to handle SQL server operations.

Provided 24x7 on-call support.

Environment: Microsoft Windows Cluster Server 2008R2/2012/2014/2016, Windows 2000/2003/2008 Server SQL 2008R2/2012/2014/2016, XML,SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSRS, SSIS, MS Visio

AIG - Fort Worth, TX Jan 2014 – Feb 2015

SQL Server DBA/Developer

Responsibilities:

Installation and configuration of MS SQL Server 2016/2014/2012/2008R2/2008 on Production and Test Servers. Worked with the Database Mirroring & Linked Servers. Rebuilding or reorganizing indexes based on the fragmentation of the indexes. Implemented 2008R2 features like Unicode compression and Report Builder 2.0/3.0.

Implemented Partitioning on OLTP table to boost up Performance. Developed SQL Quires and stored procedures to fetch databases using Joins, database linked Servers.

Configured DB Mail and created jobs in respond to any SQL Jobs that failed by sending email.

Performed DBCC commands to test the physical and logical consistency of the Database.

Worked Extensively with SSRS 2012/2008R2/2008 by generating reports like Drill Downs and Drill Through.

Efficiently used Indexes to enhance performance of individual queries for fast & reliable reporting.

Designed SSIS Packages to transfer data from flat flies to SQL Server using Intelligence Development Studio. Administrated Interface to organize reports and track reporting history.

Extensively worked on SSIS transformation such as Lookup, Merge, Derived column, Data Conversion.

Generated many SSIS Packages by using import & Export Wizard. Designed many Packages using SSIS Designer, Control Flow and Data Flow Tasks with ETL Tool.

Used DBCC trace flags to block and deadlock situations.

Properly ensured the backups by performing Backups for production and restored in the test environment.

Promptly identified and solved performance bottlenecks for memory, I/O and Disk.

Worked with performance monitor, SQL Profiler and DMV’s for Performance Monitoring.

Hands on experience with Database Engine Tuning Advisor to select and create an optimal set of indexes, indexed views, partitions and analyzed a workload and the physical implementation of the database.

On call 24/7 Support to Database on weekly rotation.

Environment: SQL Server 2014/2012/2008R2/2008/2005 with clustering, T-SQL, Windows 2003 Server, DTS, Oracle, DTS, Excel, Access, IIS.

Cognizant Technology Solutions May 2009 – Nov 2013

SQL Server Database Administrator Bengaluru, India

Responsibilities:

Interacted with various customers on day to day basis and analyzed their SQL server environments.

Analyzed various SQL server environments and suggested best practices for better performance.

Administered the space usage of the various databases for various applications.

Automated consistency check of the database (DBCC) for SQL Server.

Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.

Installed and configured SQL Server Reporting Services.

Suggested various architectures that can be implemented after upgrading from older versions of SQL server to SQL server 2005.

Proposed various high availability options to maintain the high availability of SQL server on various environments.

Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.

Created various automated processes to update the Reporting services databases on a regular basis.

Suggested and implemented various SQL Server Reporting services environments.

Upgraded SQL server 2000 boxes to SQL server 2005 and acted as the point of contact for all developers.

Upgraded SQL server 2005 to SQL server 2008 on a Clustered environment.

Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives

EDUCATION QUALIFICATIONS

Bachelors in Computer Science 2005 – 2009

Dr. MGR College of Engineering, Chennai, India

Contact this candidate