ANGELA OKOJIE

Georgia, Atlanta, • adsxen@r.postjobfree.com +770*******

SQL Server Database Administrator

Technical and determined professional with experience of over five years in designing, developing, and testing databases with Structured Query Language, configuring database servers, and securing databases against threats. Accelerated career record of suggesting improvements for database maintenance, performing support release deployment activities, and ensuring adequate backed-up database. Excel at overseeing data migration and transferring and monitoring database resource usage. Supportive leader and team player with expertise in leading the workforce toward work excellence, company objective realization, and generating value beyond numbers. Adept at understanding the big picture and envisioning solutions, while promoting prosperous environments for change and continuous company progress. Proven expertise in:

Database Design

Data Architecture

Database Administration

Data & System Security

Backup & Data Recovery

Installations & Configuration

Capacity Planning

System Troubleshooting

PROFESSIONAL EXPERIENCE

Priority, Atlanta, GA

SQL Server DBA, 2021 – Present

Determine and operated with parameters for parameterized reports in SSRS 2008.

Migrate data to a data warehouse and transferred files in various formats based on requirements by utilizing SSIS packages. Transmit email during SQL fails by preparing jobs while installing DB mail. Facilitate virtualization by utilizing basic SSIS tools and TABLEU. Document daily, weekly and monthly statistics of various investors by generating SSRS reports. Design database objects, such as tables, views, indexes, and stored procedures. Schedule reports to be produced at a predetermined time by leveraging reporting services (SSRS). Document to the end user by engaging in creation of different dashboards. Generate Entity Relationship (ER) diagrams based on requirements. Enhance the query performance by building the necessary indexes.

Key Contributions:

Ensured integration, maintenance, troubleshooting Log shipping, Mirror, Always on Availability Groups, replication SQL server Failover cluster on same and multiple subnets.

Acquired the data and transferred the data into another database by organizing the SSIS package services to different intervals.

Maintained seamless reporting to the end user by overseeing in the creation of various dashboards.

Coordinated data migration from database to text files and devised SSIS packages for file transfer from one location to the other operating FTP task by formulating SSIS Packages.

Demonstrated proficiencies in SSIS look up, Fuzzy group transformations and data flow tasks.

Developed the drilldown, drill through, and linked reports by utilizing the SSRS.

Understood the reporting conditions for multiple users by liaising with business analysts.

Wellsfargo, Atlanta, Georgia

SQL Server Database Administrator, 2016 – 2020

Accomplished administration of MS SQL Server Database while raising the Server Availability time with the optimum level of Database Recoverability by consolidating the SQL server Differential backup and LOG Backup.

Scheduled and implement disaster recovery (DR) exercises on the DR servers. Devised and executed extensive Backup plans and disaster recovery strategies implemented. Ensured database space issue, resolved excessive log growth issue, and performed normalization of DBS. Executed changes to the server, instance, and database by coordinating with other team members. Assisted Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS). Configured changes and decreased changes from production. Attained optimal outcomes by weekly Patching of Standalone and Cluster instances. Handled more than 1000 SQL servers in Clinical Research environment on 24/7 basis. Produced Clusters 2 node and 3node with Active-Active and Active-Passive. Migrated and updated SQL server from Legacy to 2014, 2016, &2017.

Key Contributions:

Developed and designed databases, table views, store procedures, and triggers by troubleshooting and fine-tuning of the database for performance and concurrency complete documentation about the database.

Performed regular health checks across thousands of servers by utilizing PowerShell script and oversaw permissions and security.

Maintained successful maintenance tasks and facilitated issue resolution by tracking daily, weekly, monthly, and quarter Maintenance Task.

Observed and optimized Performance by leveraging execution plans and Index tuning. Managed automation of repetitive tasks leveraging PowerShell.

Assisted ETL process from Oracle to SQL server, Sybase to SQL server, Access to SQL server, Excel to SQL Server.

Ensured company data organized securely, including electronic access and written format through adhering to company guidelines/regulations.

Provisioned Databases and configured proper HA/DR tactics grounded on the RTO/RPO of the Business Division.

Executed performance tuning tasks on regular basis on issues ranging from query tuning to index Optimization, Temp Db issues, to IO, High CPU usage, severe blocking, long-running query, always on out of sync, mirroring out of sync, log shipping out of sync.

Brentwood Trade Mahanttan Atlanta, Georgia

SQL Server Database Administrator, 2014 – 2016

Installed the reports by liaising with the front-end developers. Executed transactional replication and mirrored on part of Always On Availability Group.

Modified schema and performance by collaborating with the development team. Functioned under Active/Passive and Active/Active cluster environments. Configured SQL Server 2008 and 2012 on Windows server 2008. Built reports in SQL Server Environment by employing SSRS in Business Intelligence Development Studio (BIDS). Executed data mining and Microsoft analysis services. Recrafted the indexes at regular intervals for better performance. Produced DTS packages for the migration of data from SQL Server to MS Access or Oracle Databases. Amplified performance, preserve referential integrity, and delivered application functionality by creating optimized T-SQL stored procedure. Formulated groups, toles, and users and assign privileges to users. Undertook SQL questions and Stored processes by applying SQL Profiler and Index Tuning Wizard. Planned jobs and alerts using SQL Server Agent.

Key Contributions:

Streamlined transferring of data from various data sources, such as MS Access and Excel while utilizing SSIS packages.

Exported and imported data from text files and Excel to SQL Server leveraging Bulk Insert and BCP utility.

Reported complex T-SQL queries by using stored procedures, functions, and views.

Oversaw schema objects such as tables, views, indexes, and referential integrity depending on user requirements and converted into technical specifications.

Improved performance of individual queries for fast and efficient reporting by leveraging Indexes.

Researched results of the test by devising reports Execution of SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various categories of users.

EDUCATION

B.S.C in Accounting & Information Systems University Of Lagos Nigeria, 2004

Diploma in Social worker Edo States university, 2000

CERTIFICATION

Scrum Master Accredited Certification™

TECHNICAL SKILLS

Database Configuration Assistant DTA SQL Profiler PowerShell DMVS DMFS Query Analyzer SQL Server 2008, 2012, 2014, 2016, 2017, 2019 MS Access Oracle 11g, 12c & 18c. SSIS SSRS & SSAS UNIX Shell Script Database design Azure AWS DTS DBCC BIDS Data Transformation Services Windows

Contact this candidate