Professional Summary:

Professional and progressive experience in SQL Server Database Administrator in the management of complex SQL Server database systems, Data Analysis and core experienced in the areas below.

Areas of Strength:

SQL Server Database Administration 2005, 2008, 2008 R2, 2012

Professional Training

Microsoft SQL Server 2012 Database Administration Certification

Confidential

• SQL Server 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, SQL Server 2012 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 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, 2008 R2 and 2012.
• Troubleshoot databases and custom application issues. Develop and document SQL coding guidelines.
• Knowledge acquired to 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.
• Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
• Create reports that ran daily for jobs running in SQL Server Agent.

Professional Experience

SQL Server Database Administrator

Confidential

• Responsible for installing the SQL Server database instances in all environments including but not limited to development, Quality Analysis and Production.
• Monitor and maintain all SQL Backups and Restoration tasks. Monitor SQL Server Jobs SQL Server Agent and Maintenance Plans Jobs .
• Develop and creates stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Responsible for supporting the SQL Server databases and ensuring their performance, availability and security.
• Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance. Pro-actively monitor the database systems to ensure secure services with minimum downtime.
• Provides trend analysis to the service management team to enable them to make informed decisions regarding resource management. Improve and manage maintenance of the databases to include Deployments and Upgrades.
• Responsible for implementation and release of database changes as submitted by the development team.
• Responsible for security and non-security patches based on company approved maintenance schedules.

Database Administrator - IT Asset Management

Confidential

• Managed Georgia State Department of Revenue statewide IT Assets Management Software, Hardware and Capitol Assets .
• Analyzed and supported the Database with SQL Server Analysis Services SSIS and SQL Server Management Studio SSMS
• Maintained the legacy database and other tools in Access and SQL Server compiling analysis of security policy implementation and compliance using T-SQL.
• Optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Analyzed services in support of strategic and operational reporting and analytic needs monitored and analyzed assets conditions, purchases, assets inventory, lifecycle, surplus, and pipeline data against forecasts and quotas
• Managed software and hardware lifecycle, fleets, surplus and retired assets on inventory database by ensuring assets are properly accounted for. Migrated data acquired in a merger to a legacy database system.
• Analyzed complex information from different sources within and outside the divisions and the department in general. Communicated with various individual, vendors, clients and divisions.
• Consulted on the design and implementation of a contract database application and a web-based distribution mapping tool- user interfaces, data schemes and graphics.
• Analyzed, Audited and updated Database of all Department of Revenue's IT assets properties at the Head Office, all Regional Offices and Local Government Services across Georgia State Albany, Athens, Augusta, Columbus, Douglas, Lithia Spring, Macon, Rome, Savannah, Valdosta, South Atlanta Metro Office and Chamblee Warehouse .

SQL Server Database Administrator

Confidential

• Installed and configured multiple SQL instances in production environments.
• Implemented and supported High Availability Solutions by configuring log shipping and mirroring across multiple SQL Server instances. Engaged in disaster recovery DR strategic planning and implementation in SQL Server
• Performed data refreshes on SQL Server production and test databases.
• Managed SQL Server database security by granting permissions securable to the principals.
• Automated various routine maintenance tasks like backups, index reorgs, index rebuilds on all production databases
• Ensured that all database related trouble tickets are delivered upon within the SLA.
• Generated the weekly, monthly, monthly and quarterly report by using SQL Reporting Services.
• Wrote, evaluated and optimized complex SQL codes, stored procedures and scripts for maintenance and reporting purposes.
• Responsible for the daily maintenance tasks and health check of all SQL Server databases

Operations Database Analyst

Confidential

• Used SQL profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Performed DBA duties including Database Backups, Restores, Performance Tuning and Capacity Analysis.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis. Developed, created stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

IT Business Analyst

Confidential

Analyzed the feasibility of, and developed requirements for, new systems and enhancements to existing systems ensured the system design fits the needs of the users.

Project Control Analyst

Confidential

Responsible for Project analysis, manipulation and interpretation of project/market data to produce management reports.