Executive Summary:

Satisfying and challenging positions to utilized and build on the considerable skills and experience I have already acquired and developed.

Core Experience

• Data Migration
• Backup and Recovery
• Installation and Upgrade Integration Service
• Performance Tuning Disaster Recovery
• High Availability

Skills Summary

• Database Installation, Configuration and Maintenance, Administration of SQL Servers 2008R2/2012.
• Implementing High Availability of database servers using Database mirroring, Log Shipping and Clustering. ETL using SSIS- Data Warehousing.
• Creating jobs, Alerts, SQL Mail Agent.
• Perform integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities. Experience on 64 bit SQL Server 2012.
• Ability to work in a fast paced environment, Good team player and who can also work independently. 24 X 7 Production Database on Call Support.

Career Profile

• Detail-oriented, efficient and organized professional with experience in accounting systems.
• Possess strong analytical and problem solving skills, with the ability to make well thought out decisions. Excellent written, oral communication and time management skills.
• Highly trustworthy, discreet and ethical.
• Resourceful in the completion of projects, effective at multi-tasking. High sense of urgency and Flexible to working overtime.

WORK EXPERIENCE

confidential

SQL Server DBA

• Tools like SQL Profiler and SQL trace for troubleshooting, monitoring, optimization of SQL Server
• Engaged as demand in DBA duties including: database backups, restores, performance tuning, and capacity analysis. Develop, modify, and optimize stored procedures, triggers to handle complex business rules and history data
• Management of production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and SSIS packages.
• Tuned stored procedures, advanced queries, triggers, views, indexes, and functions for databases. Team with end users to define, implement, and maintain their reporting requirements.
• Participate and coordinate the creation, modification and maintenance of database structures.
• Full management of database users and security: Assigning users to data bases and determining the proper security level for each use also assign permission to the various database objects such as, Tables, Views, and stored procedures
• Create, deployed and managed ad-hoc report using the SQL SSRS reporting tool.
• Demonstrated high level of understanding of database internals and application database components e.g. triggers, functions, packages
• Provided consultation, training and mentoring to all application developers in database management practices as it pertains to SQL databases
• Knowledge of installing and implementing Microsoft SQL Azure the cloud based database solutions.

SQL Server DBA

• Use SQL Profiler for troubleshooting, monitoring, optimization of SQL Server
• Perform DBA duties including: database backups, restores, performance tuning, and capacity analysis.
• Develop, modify, and optimize stored procedures, triggers to handle complex business rules andhistory data
• Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and SSIS packages.
• Create stored procedures, advanced queries, triggers, views, indexes, and functions for databases. Work with end users to define, implement, and maintain their reporting requirements.
• Participate and coordinate the creation, modification and maintenance of database structures.
• Manage database users and security: Assigning users to data bases and determining the proper security level for each use also assign permission to the various database objects such as, Tables, Views, and stored procedures
• Demonstrate an understanding of database internals and application database components e.g. triggers, functions, packages
• Develop, deployed and managed ad-hoc report using SSRS.
• Applied knowledge of database design standards and database management systems DBMS to the resolution of daily database issues.

• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor. Configured Database mail, linked servers in SQL server 2005.
• Creation and scheduling of Maintenance plans database and log backups and cleanups , DTS to SISS package conversions.
• Implemented MS SQL Cluster Active/Passive Active/Active , Multi Node Cluster up to 8 Node for high availability.
• Writing, debugging, and tuning Transactional SQL, ETL and stored procedures for developers and customers SQL Server database physical model creation and implementation data type, indexing, table design
• Developed, deployed and managed SSIS, SSAS, SSRS and published them for end users
• Setting up and administering SQL Server Database Security environments using Profiles, database Privileges and Roles.