We provide IT Staff Augmentation Services!

Ms Sql Dba Consultant Resume Profile

3.00/5 (Submit Your Rating)

Atlanta, GeorgiA

DATABASE ADMINISTRATOR/DEVELOPER

Experienced Database administrator DBA with experience designing, coding, testing and supporting next-generation database solutions SQL Server environment. An accomplish Database Administrator with demonstrated success designing and implementing database solutions that improve business functionality. Possess diversified background with Enterprise Systems Solutions. Proven ability to implement technologies that decrease costs, increase performance, and positively affects the bottom line.

AREAS OF EXPERTISE

  • SQL Server Installation and Implementation Disaster Recovery Performance Tuning
  • Database Security Backup Restore Replication
  • Database Mirroring Log Shipping Database Maintenance
  • Extract Transform Loading ETL SQL Server Integration Services SSIS Data Migration
  • SQL Server Reporting Services SSRS T-SQL

PROFESSIONAL EXPERIENCE

Confidential

MS SQL DBA Consultant

  • 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.
  • Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.
  • Design and implement SQL Server 2005, SQL Server 2008 R2 databases for mission-critical business.
  • Knowledge of Disk and Server configuration through Raid for SQL Server.
  • Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
  • Develop and modifystored 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.
  • Troubleshoot databases and custom application issues.
  • Work with end users to define, implement, and maintain their reporting requirements
  • Assists in the design, coding, testing and implementation of high volume transactional OLTP SQL databases instances.
  • Developand document SQL coding guidelines.
  • 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.
  • Perform other duties assigned by management.

Environment:Window server 2005,2008 SQL Server 2005,2008R2

Confidential

Computer Programmer/Analyst

  • Strong Problem-solving skillstotroubleshoot and identify equipment and component failures due to extensive knowledge of various communication interfaces with several types of software programs
  • Exercised Sound Judgmenttohandle unique issues not always covered in manuals and policy guidelines.
  • Interpreted and applied agency regulations, requirements, and practices to mitigate risk and promote quality assurance processes.
  • Exhibit Excellent Customer Serviceto diagnose and resolved problems in response to customer-reported incidents.
  • Worked well with both internal and external customers to assess needs, provide information, and resolve problems.
  • Strong commitment toward customer satisfaction and provided quality products and services.
  • Create technical documentation to support maintenance of the applications
  • Project Analysis and reading and interpreting technical data reports.
  • Design and code applications that solve a variety of major business issues.

Environment: UNIX C compiler Visual Basic SYBASE

We'd love your feedback!