Apata Regina

ad0o8i@r.postjobfree.com

623-***-****

Professional Summary

Regina has served as an innovative Data Base Administrator in multiple projects, delivering extra ordinary value to various organizations. A great team player and a problem-solver, always paying close attention to details and communicating effectively to every stakeholder. My aim is to always be the best at everything I do so am open to always developing my skills and learning new skills to be effective. I have almost 8 years’ experience with MSSQL, and 7years passed of Oracle Database Administrator.

Certification, Training and Skillset

Scrum Master Certification

MS Azure Advance Certification

SQL Fundamentals Associate Certification

OCA, OCP

AWS Associate and Advance

Bs Computer Science 2009 University of Lagos Nigeria

Excel (Advanced)

MS Word (Advanced)

MS PowerPoint (Advanced)

Sharepoint

Jira

Power BI

Postgres fundamentals

Azure Security Center

Big Data Platforms (Azure, Databricks)

Database version 12.0,13.0,14.0 Mssql 2012,2016, . SSIS, SSRS SSAS T-sql, sql fundamentals, Azure.

SQL Server 2000, 2005,2008,2012,2016,2018 on Windows 2007,2010

Data Privacy, Identity and Access Management (IAM), Cryptography / Key

Education: -

University of Lagos Nigeria

Bachelor of Science - BS, Computer/Information Technology Administration and Management

Mar 2006 - Jun 2009

WORK HISTORY

Wells Fargo

Jan2016- Present

SQL Server Production DBA

Roles and Responsibilities

Working on several IT change programs, with focus on systems replacement and development.

Manage SQL server databases through multiple product life cycle environments, from development to mission-critical production systems.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.

Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.

Refine and automate regular processes, track issues, and document changes.

Assist developers with complex query tuning and schema refinement.

Perform scheduled maintenance and support release deployment activities after hours.

Share domain and technical expertise, providing technical mentorship and cross-training to peers and team members.

Migrate data from enterprise-hosted databases to cloud-hosted data services like AWS RDS.

Work with the following tools and technologies: MS SQL server administration; performance tuning and optimization (PTO) using native monitoring and troubleshooting tools; backup, restore, and recovery models; windows server, including active directory; high availability (HA) and disaster recovery (DR) options for SQL server; and leading cloud platforms like AWS, Azure, or Google Cloud.

Travel / relocate to various unanticipated locations to interact with clients and train users for short and long-term assignments.

Migrating data from one platform to the other using tools like winscp and securecrt file transfer. Migrating data from one platform to the other using tools like winscp and securecrt file transfer.

Expertise in T-SQL, DW Concepts, Tabular Cube.

Monitoring postgress db and creating users and granting privileges as needed.

Deploy scripts created by developers.

Design an implementing new structural tables by using ewin.

Design instance for the database as required

Montgomery County federal Credit Union

Jan 2011-Dec2016

Junior BA/Data Analyst

SQL Server Production DBA

Installation and configuration of sql server management studio 2012, 2016. Creating new instances,

Database import new data (csv files). Patching, Upgrade, migration of sql server database from 2012 to 2016. Perform refreshes and debugging hard queries from a data virtualization platform.

Creating users, granting privileges, Monitoring audit logs and run audit for developers to know what they are doing.

Configure Azure platform and link servers to another server.

Configure monitoring with stack flow and toad for sql. Using Ewin for data engineering and adding tables to the database.

Work on a 24/7 support using t-sql scripts for critical systems.

Design and develop MSSQL automation workflow.

Using different virtualization tools to manage the sql server database (Denodo)

Migrating data from one platform to the other using tools like WinSCP and securer file transfer. Migrating data from one platform to the other using tools like WinSCP and securecrt file transfer.

Performing deployment as needed by the developer.

Creating administration account for denodo and linking them to active directory.

Rebuilding indexes to increase performance. Dropping used and unuse indexes and creating new once.

Implementing new strategy for disaster recovery by creating always on availability groups.

AT$T Silver Spring MD

Jan 2009 Dec2010

SQL Server Production DBA

Installs, configures, and maintains Databases as per product requirement and industry best practices. Ensure that database is available, secure, healthy, efficient, and recoverable as expectations.

Performing regular system review using Solar wins, plan and implement solutions for current and future needs.

Run database maintains as required, backup and restores different databases.

Complete first level of analysis (CPU, memory, space, blocking sessions, failed jobs, tuning queries for performance etc.)

Create database users/logins and security groups. Making sure that all privileges are set as required.

Performing database import and export of CSV files, migration, upgrade, patching from one system to the other.

Rebuilding cluster and non-cluster indexes off and online.

Design and develop MSSQL automation workflows using Python and PowerShell.

Import and Export csv files from one database to another using MSSMS Import and Export wizard.

Recover tables from existing backup tables. Making sure that tables match their character sizes.

Data Modeling Skills compare two different environment using ERWIN Data Modeling tool.

Migrating data from Oracle to SQL Server Environment using WinSCP.

Apply MS Patch, version control and vulnerability management as needed.

Migrating data from one platform to the other using tools like winscp and securecrt file transfer. Migrating data from one platform to the other using tools like winscp and securecrt file transfer.

Using operating system like linux, Unix and Aix for creating of database mount point and job scheduler

Making changes on batch profiles as required on a linux operating system.

Contact this candidate