Ayo B.

Database Administrator

915 dollar
Freelancer
9 years
New York, UNITED STATES

My experience

More

Citibank (Citigroup)August 2020 - Present

* Perform daily maintenance including monitoring backups, managing disk space, and maintaining database objects
* Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
* Participate in change management processes including deployment of database changes in all environments as requested; following client change management standards and procedures
* Maintain client documentation including database topology, connection procedures, and special instructions
* Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance.
* Maintained server security by assigning logins, server and database roles and server permissions.
* Installed, configured and maintained MS SQL Server Replication for production servers to provide high availability.
* Performed database backups for production, test and development servers and restored backups onto test servers to confirm the success of the backups.
* Documented changes made to the servers, including documentation of performance issues.
* Developed stored procedures, triggers and functions
More

Field NationJune 2017 - July 2020

* Proactively managed the MySQL database environments, and SQL server to identify performance issues within the environment (at both the server level and physical table design) and assist in tuning, root cause analysis and remediation.
* Assisted application development with logical & physical database design considerations, database refreshes, cloning, and backups.
* Performed database changes and code promotions according to Enterprise Change management processes and standards.
* Responsible for reviewing and tuning Oracle and technology-specify database coding technologies (PL/SQL, isql, etc.)
* Performed upgrades and security patches to databases as required.
* Provided service and support determined by the current Service Level Agreements, including 24 x 7 rotational on-call support for production databases.
* Responsible for performance tuning and ensure high availability of infrastructure, including operating system and storage subsystem
More

RegCharles FinanceJanuary 2013 - May 2017

* Provided ad hoc analysis through data extraction and file creation for use by Marketing teams in reporting, analysis and predictive analytics
* Leveraged customer databases and other sources of data to report, monitor and analyze critical business metrics across the enterprise
* Developed and automated standard reporting that provided visibility to key metrics for the marketing organization
* Streamlined and improved reporting processes and procedures on an ongoing basis to maximize efficiency and productivity
* Provided customer segment overviews incorporating segment composition, migration patterns, performance trends, and direct marketing engagement strategy (emails, catalogs, credit line increases, etc.)
* Installed and configured Postgres databases and applied security patches and upgraded existing installations
* Supported PostgreSQL database in both locally hosted servers and on AWS, including exposure to setting up AWS RDS instances
* Works with teammates to migrate Oracle databases to the Postgres platform

My stack

Business Intelligence

SQL Server Reporting Services, ETL, SQL Server Integration Services

Others

Analytics, Enterprise Manager, Performance tuning, Project Management

Databases

Oracle, Database Administration, SQL Server, Microsoft SQL Server 2005, MySQL, Microsoft SQL Server, PostGreSQL, Database Engine Tuning Advisor

Technologies

AWS

Environment of Development

BIDS

IT Infrastructure

Active Directory, Linux

Languages

Oracle PL/SQL, PowerShell, SQL, XML

My education and trainings

Bachelor of Arts, Psychology & Linguistics - UNIVERSITY OF GHANA

Master of Arts, Forensic Psychology - FAIRLEIGH DICKINSON UNIVERSITY