SUMMARY

• Experience with Microsoft SQL 2008 and above in an enterprise environment
• Deep noledge of Microsoft SQL databases and administration of those databases on Windows platforms
• Excellent problem solving and analytical skills, and the ability to manage multiple projects under strict timelines, as well as the ability to work well in a demanding, dynamic environment and meet overall objectives
• Experience interfacing in a technical design role with IT and business stakeholders to properly specify and implement complicated database designs in a 100% virtualized environment
• Ability to troubleshoot and optimize MSSQL database configurations based upon a thorough noledge and understanding of IT and Industry best practices and the ability to convey complicated database concepts to non - IT and/or business stakeholders.
• Solid experience in setting up and supporting SQL Server Mirroring, Log Shipping, Mirroring/log forwarding, Clustering and other methods of disaster recovery
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations
• Solid experience in database migration from one platform to another, patching, upgrade, data loading, security, capacity planning, performance monitoring and tuning
• Ability to analyze traces, debug stored procedures, triggers and package
• Experience in database design and some logical modeling noledge
• Solid understanding of Windows operating system, LDAP and Active Directory
• Expert understanding of Database Architecture, Operating Systems, Client/Server Architecture, Middleware and Hardware (Servers, SAN, Network)
• Solid experience in administering SQL Server High Availability and Disaster Recovery strategies
• Ability to take ownership and good skills on problem management, problem solving and prevention of SLA breach under Incident / Problem Management processes
• Expertise in T-SQL writing stored procedures, triggers and functions
• Production support in a 24/7 environment and project support.
• Installed and Upgraded 2008 R2/ 2012 and 2014 database standalone / cluster instances.
• Translating business requirements into conceptual, logical and physical data models
• Performance tuning and query Optimization
• Production Database on call in a 24 X 7 support environment
• SQL Server Performance Dashboard Reports for Monitoring
• Performance Baselining
• Monitored performance of applications and programs after implementation, taking actions as required
• Managing complex add-ons in (SQL Server 2000- 2016)
• Designing, Developing and implementing Databases
• Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events, Red-Gate tools etc.
• Replication Models (Snapshot/Transactional/Merge)
• Clustering Setup, Troubleshooting and Management
• Expert in 2008/2012/2014 SSIS and Reporting Services (SSRS)

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Administrator

Responsibilities:

• Monitored performance and managed parameters to provide fast response to front-end users and other members of the IT Applications team
• Installing and testing new versions of the DBMS
• Maintained data standards, including adherence to the Data Protection Act
• Wrote database documentation, including data standards, procedures and definitions for the data dictionary
• Designed, writes, and maintains database support tools, database tables and dictionaries and recovery and back-up procedures.
• Collaborated with technology/infrastructure staff to identify data relationships and functional requirements.
• Analyzed and resolved issues related to information flow and content
• Performed activities related to the day-to-day administration and maintenance of database systems.
• Handled installations, upgrades, backups, and configuration.
• I was able to setup and support SQL Server Mirroring, Log Shipping, Mirroring/log forwarding, Clustering and other methods of disaster recovery
• Provided technical assistance by responding to inquiries regarding errors, questions and problems
• Analyzed, installed and tested upgrades pf product
• Handled Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
• Developed, managed and tested back-up and recovery plans
• Ensured dat storage and archiving procedures were functioning correctly
• Worked closely with IT project managers, database programmers, and report developers
• Communicated regularly with technical, applications, and operational staff to ensure database integrity and security
• Archived data and maintained appropriate log and database growth
• Owned, tracked and resolved database related incidents and requests and resolving incidents within SLAs
• Reviewed service related reports on a daily basis to ensure service related issues are identified and resolved within established SLAs
• Responded to database related alerts and escalations and worked with database engineers to come up with strategic solutions to recurring problems

Confidential

SQL Server Database Administrator

Responsibilities:

• Installed SQL Server 2008 on advanced servers, applied security fixes
• Migrated SQL Server 2005 Servers to SQL Server 2012
• Maintained database response times in 24X7 Production environments
• Proactively generated performance reports.
• Planned and implemented database backup/restore and disaster recovery
• Analyzed business requirements and build logical data models dat describe all the data.
• Developed SQL scripts for maintaining administration tasks.
• Managed SQL database cluster, replication and mirroring
• Performed T-SQL programming
• Installed and configured SQL databases setups
• Managed performance issues on production SQL servers and tuning T-SQL queries to improve performance
• Monitored standby databases to ensure high availability