Professional Summary:

Experienced, self-motivated, creative, focused, time-efficient, and dedicated professional. Possess excellent interpersonal skills and the ability to conduct research and courage to sometimes adopt untested outcomes of research and innovation. Have more than 5years experience in MS-SQL DBA, Windows Server, and SQL Database Administration from diverse industries, including retail, manufacturing and high-tech environments managing more than 2,000 MS SQL instances, 250 databases, clustered, replicated and mirrored mixed 2000,2005, 2008, and 2012 MS SQL environments. Familiarity with SQL Server 2014.

Areas of Strength:

• SQL Server Installation and Implementation Disaster Recovery Performance Tuning
• Database Security Backup Restore Replication
• Database Mirroring Log Shipping Database Maintenance
• Extract Transform Loading ETL SSIS, SSRS, SSAS Data Migration Virtualization VMware

CORE COMPETENCIES

• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, index maintenance in a very large high-transaction and fast pace environment.
• Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Design and implement SQL Server 2005, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 databases for mission-critical business.
• Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
• Develop and modify stored procedures, queries, triggers, views, indexes, and functions to handle business rules, history data and audit analysis.
• Use Data Transformation Services DTS /SQL Server Integration Services SSIS and Extract Transform Loading ETL tools of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Configure and support SSIS and SSRS for SQL Server 2005 and 2008 R2, SQL Server2012 and SQL Server 2014.
• Knowledge acquired to work with end users to define, implement, and maintain their reporting requirements.
• Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
• Create reports that ran daily for jobs running in SQL Server Agent.
• Knowledge with monitoring and troubleshooting in 24x7 operations.

Professional Experience

Confidential

MSSQL DBA

• Work with a team of 25 staff in the development, design, and implementation of new applications and changes to existing hardware systems and software packages, resulting in increase in efficiency and return on investments for clients
• Responsible for Windows troubleshooting of all incoming incidents and performs requests for service.
• Assists in the design, coding, testing and implementation of high volume transactional OLTP SQL databases instances.
• Develop and document SQL coding guidelines.
• Create reports that ran daily for jobs running in SQL Server Agent.
• Responsible for maintenance, Backup Recovery, testing, alerts job failures, database server capacity and database integrity checks Manage the deployment, upgrades, and maintenance of hardware, software, desktop operating systems, and printers
• Security, auditing, configuring, documenting, enhancement corrective changes, emergency changes
• Participate in DBA On-call monthly and document environments and processes where applicable
• Work with other DBA team members and various application teams
• Setup and administer SQL Server Database Security environments using profiles, database privileges and roles to prevent data theft and increase data integrity
• Database maintenance, replication and tuning
• Migration of systems data from different databases and platforms to MS-SQL databases
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers

Confidential

Production Specialist / Database Administrator

• Responsible for supporting sales and fine tuning of end-user access to orders database, both in person and through supply chain management software. Also responsible for managing data updates on critical to business operations, including information displayed on the company website and Gift Certificate validation data using front-end My SQL application
• Assisted in the design, coding, testing and implementation of high volume transactional OLTP SQL databases instances.
• Developed and documented SQL coding guidelines, Created reports that ran daily for jobs running in SQL Server Agent.
• Primary point of contact for customer purchase and technical related issues, providing telephone support to customers to ensure the prompt and courteous resolution of service and technical related problems from customer accounts
• Responsible for coordinating data access for dock pickup and delivery times with customers and installers, thereby optimizing delivery efficiency, maximizing cost control, and maintaining customer satisfaction.

Confidential

Ingalls is a leading behavioral healthcare service provider

Database Specialist

• Assisted in the design, coding, testing and implementation of high volume transactional OLTP SQL databases instances.
• Developed and documented SQL coding guidelines, Created reports that ran daily for jobs running in SQL Server Agent.
• Accountable for the timely, efficient upgrades of patient health information databases for the behavioral health services and support services to end user terminals and physician practices requiring strong attention to detail, organizational skill, and the ability to maintain tight delivery schedules.
• Accountable for data updates into patient health information database for HIPPA regulatory compliance by logging various aspects of client treatment interventions programs using secure health information management access terminal.

Confidential

Database Specialist

• Responsible for the day-to-day database and management operations of a psycho- therapy terminal databases for client access service delivery and customer account management with an average of 400,000- 600, 000 in annual revenue.
• Accountable for data updates into patient health information database for HIPPA regulatory compliance by logging various aspects of client treatment interventions programs using secure health information management access terminal.

Confidential

Coordinator for Cooperation Services Database Terminal

• .Migration of systems data from different databases and platforms to MS-SQL databases. Provided exceptional levels of support and customer service to all University guests, visiting researchers and exchange faculty / students within the Divisions of Research and Cooperation
• Responsible for updating inter-University research databases and implementing regulatory compliance mandates through the coordination of research accreditation, immigration and consular service needs for international exchange guests of the University.