Database Administrator Energy Engineering

Pamela Chigozie Anyakorah

Phone: 346-***-**** Email: adrswu@r.postjobfree.com

Database Administrator

Environments:

Microsoft SQL Server Services, SQL Server2005/2008/R2/2012,2014/2016 SSIS, SSRS, MS Access, MS Power Shell, Windows Operating Systems (XP, Vista, 7, 8, 8.1 and a forehand Knowledge and research of windows 10), Microsoft Office Suite, Share Point.

About Me

Highly proficient database administrator spanning five years’ experience with relational management database in production, development, test, cluster and replication server environment. Great self-starter and well-structured in performing patching and upgrading of SQL Servers and scheduling monthly patching of Windows Server Environments

Key Skills

Extensive experience in installation, upgrades, and configuration of MS SQL Server 2012/2016/2019 versions

Hands on knowledge of data base tools such as database engine tuning advisor, Query Analyzer, SQL Profiler.

Experience in high availability solutions like Database Mirroring, Always on Availability, Clustering and so more.

Skilled at Performance tuning, Troubleshooting and fixing issues that arises.

Efficient use of TSQL to create, alter and drop data base objects such as views, stored procedures, triggers, user defined function, synonyms, and subqueries

Skilled at scheduling jobs and alert using SQL Server Agent, implementing SQL Logins, roles, and authentication modes as part of security policy, and performing capacity planning and forecast of storage, database growth and server utilization

Solid Understanding of backup, recovery strategies, and Ola Hallengren maintenance solutions.

Supporting SSIS and SSRS packages when needed.

Professional Experiences

SQL DATABASE ADMINISTRATOR BRAISE LLC (TYLER TECHNOLOGIES) JULY 2020 – PRESENT

Optimize data retrieval time from multiple four terabytes databases by implementing best practices such as indexing, maintenance jobs and statistics updates

Experience working with SQL Server 2012,2014,2016,2017 and 2019.

Experience in resolving ticketing issues using Service Now and internal built tool

Working with AG and Clusters as HA and DR solutions in the environment

Experience in migration and upgrade projects

Monitor and test DB performance for potential bottlenecks, identify issues with solutions, and work with co-workers and/or outside resource to implement fixes.

Creating Logins and mapping users to specific database needed and Revoking Access when necessary

Attend Cab meetings, Capacity planning, Monitoring and Alerting meetings, Daily Standup, Kanban meetings, DBA team meeting touchpoint

Support SQL Servers in different environment like TEST, DEV, PRE-PROD, UAT, PRODUCTION and FEDRAMP Environments.

Experience with BACKUP and Restore utilizing DDBOOST.

Perform patching to maintain current versions of SQL

Troubleshooting and resolving issues with SSRS Logon issues, Certificate issues.

Perform database tuning and performance monitoring, performed general technical troubleshooting and give consultation to development teams.

Implement a procedure to alert DBA and application team if availability of disk space is lower than the threshold limit.

Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning

Monitor database growth trends and develop capacity planning and data archival strategies.

Experience with Database Refresh from Prod Environment to Lower Environments.

Troubleshooting and resolving Memory consumption issues, CPU spikes.

Participate in projects like Password Remediations, Q-Radar, SOX Reports,

Participate in weekend deployments

Being Proactive in the environment

SQL SERVER DATABASE ADMINISTRATOR TECH GROUP(ENTRUST) AUGUST 2017 – MARCH 2020

Performed administrative activities like Database Maintenance, Indexing Large Databases, Database Tuning, Query Optimization and Database Backup & Recovery.

Created store procedure to automate back up and restores for automate deployment process.

Prepared project related documents like SQL Server installation and migration.

Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014

Worked on scheduling jobs via SQL Server agents, executing scripts, building and maintaining servers as at when required.

Configured database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.

Resolved issues related the long running SQL queries

Worked on High Availability solution process

Worked in Query analyzer and profiler for tuning queries using variable for characteristics and query costs

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency

Deployment of code/Builds into QA and Production environments

Deployment of code/Builds into QA and Production environments

Documented best practices for ongoing production support

Automated DB Refreshes Production to QA/Staging/Development based on user requests or

Application team needs

Worked as on call support DBA in a 24x7 environment on a weekly rotational basis

DATA PROCESSOR APX SYSTEM NOVEMBER 2016 – JULY 2017

Keep records of all computer supplies needed to operate the computer lab (such as disks, printer ribbons, printer paper, mouse pads, headphones, microphones, etc..

Manage their use and ensure that orders are placed for inventory re-supply Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data.

Maintain audit records of all equipment used in the department and any equipment on loan to other departments.

Advise on the purchase of new equipment on government contracts and compare this equipment with the technology standards.

Ensure that the equipment purchased is of the proper quality to perform the university's basic needs and to get the best equipment possible within the budget available.

Serve as point person in my department when it comes to suggesting to the administration how much and what kinds of equipment are needed.

Education

BACHELOR OF SCIENCE: ENERGY ENGINEERING

Pennsylvania State University

Contact this candidate