Sign in

Sql Server Data

Kennesaw, Georgia, United States
January 12, 2018

Contact this candidate





Bachelor of Science in Mechanical Engineering - University of Nnamdi Azikiwe, Nigeria

Summary of Qualifications

●Over 5 years of experience as DBA in development, QA/Test and production environments.

●Manage internal databases, from planning and testing stages through implementation and support.

●In-depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for nationwide offices.

●Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008/2008R2,2012,2014

●Experience in configuring and managing database high availability such as mirroring, replication and log shipping.

●Knowledge of Batch scripting, T-SQL Scripting and PowerShell

●Excellent analytical, communication and interpersonal skills. Proficient in technical writing and a good team player.

●Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Academic Background

●Bachelor of Science, University of Nnamdi Azikiwe.

●Programming Language Certifications, Dove-Techno Inc.

Technical Overview

●Databases: MS SQL Server 2000/2005/2008/2008R2/2012

●Languages: SQL, Transact-SQL (T-SQL), Batch Script, Power Shell, XML

●Operating Systems: Windows 2000/2003/NT/XP/Vista/7/8

●SQL Server Tools: SSMS, SSCM, SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, PerfMon, Database Engine Tuning Advisor (DETA)

Professional Experience

eVestment Center Dec. 2015 -- Present

SQL Server DBA/Remote

●Worked extensively with Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs.

●Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

●Designed and created databases, tables, views, store procedures and triggers.

●Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.

●Designed and implemented database modules such as full text search, large volume database updates.

●Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

●Monitored and modified Performance using execution plans and Index tuning.

●Responsible for all aspects of database administration for SQL Server databases including problem solving, configuration, and implementation efforts for large and / or complex projects with an emphasis in operation excellence and continuous improvement of database related processes and procedures.

●Responsible for on-going monitoring, maintenance, tuning, backups, and recovery of SQL databases ensuring high levels of data available and database performance.

●Configure and administer database high availability solution such as mirroring, replication and log shipping.

●Tunes and optimizes SQL Statements, Instance Parameters, and Data Storage, including the identification of performance related issues.

●Manages and maintains all production and non-production databases.

●Updated database systems by reviewing, planning, testing and installing database security patches and service packs.

●Design of physical data storage, maintenance, access and security administration and correct functioning of backup and recovery on DBMSs.

●Oversees ongoing improvements and the feasibility of systems enhancements.

●Data Import and Export

●Ensuring that project and program deliverables and benefits align with customer objectives

●Writing, debugging and Tuning Transactional SQL, ETL and Stored Procedures

●Index management/defragmentation

●Extensive use of T-SQL in my day to day operational activities

●Auditing of windows and server activities

●Creation and deployment of reports using SSRS in BIDS/Report Server

Environment: MS SQL Server 2012 /2008R2/2008/2005, Management Studio, BIDS, SSDT, T-SQL, SSIS, SSRS, SQL Profiler, Query Analyzer, Windows 2003/2000 Server, Filezilla, OpenVPN, Notepad++

Prime Revenue Feb. 2014 – Nov. 2015

SQL Server Database Administrator

●Maintained data integrity by performing validation checks.

●Involved in running the SQL Profiler for better execution Plans.

●Installed Microsoft Service Packs/Patches/Hotfixes.

●Scheduled automated jobs using SQL Server Agent.

●Altered, Modified and Created Tables, Views and Sequences.

●Involved in Fine tuning of database objects and server to ensure efficient data retrieval.

●Data migration (Import & Export using BCP) from text to SQL Server 2008.

●Planned data backup strategy for disaster recovery.

●Worked with Dynamic Management Views (DMV) for improving query performance.

●Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor (DETA)

●Proficient with SQL server agent for scheduling jobs.

●Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables

●Used SQL Profiler and Windows System Monitor for Performance Monitoring.

●Used Perfmon, DMV's, and SQL Profiler for capturing the activities of databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.

●Created and scheduled Backup jobs, index maintenance jobs, consistency checks and update statistics.

●Created linked servers for distributed queries/linking other network servers

●Documented migration process, database creation, monitors, and load scripts.

●Administered database BACKUP and RECOVERY.

Contact this candidate