CHUKWUMA EZENANDU
ac30lg@r.postjobfree.com.
Education:
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.