Database Administrator Sql Server

Salieu Sesay

**************@*****.***

Ph: 267-***-****

Summary

• Experienced Database Administrator with over 6 years of experience managing and maintaining complex database systems.

• Extensive experience in database administration, maintenance, and optimization, with a focus on Oracle and SQL Server environments and NOSQL.

• Utilized RAIK (Redundant Array of Independent Kernels) technology to implement high- performance and fault-tolerant storage solutions, enhancing data availability and system reliability in multi-node cluster environments.

• Conducted regular database performance monitoring and tuning activities, analyzing SQL execution plans, optimizing query performance, and implementing indexing strategies to enhance overall system efficiency and response times.

• Proficient in database backup, recovery, and disaster recovery strategies

• Skilled in performance tuning and query optimization, using tools such as Oracle Enterprise Manager and SQL Server Management Studio

• Experienced in designing, implementing, and maintaining database solutions to support business needs

• Familiar with cloud database technologies, such as Amazon RDS and Azure SQL Database

• Proficient in scripting and automation using PowerShell, Python, and Bash

• Experienced in working with database-related technologies, such as ETL tools, reporting tools, and BI platforms

• Skilled in collaborating with cross-functional teams, including developers, system administrators, and business stakeholders

• Effective communication and documentation skills, with the ability to present complex technical information in a clear and concise manner.

• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottleneck in the database environment.

• Excellent communication skills, co-ordinate and communicate with system administrator, network engineer, business data analysis and development team.

• Experience as On-Call production DBA support.

• Hands on training on performance tester using load runner and JMeter. TECHNICAL SKILLS

Database Skills: Oracle 19c/12c/11g/10g/9i, Oracle GoldenGate, Physical Data Guard, RAC Hardware: Sun Sparc E series, HP 9000, IBM RS6000, Compaq, EMC, UCS blades Operating Systems: Sun Solaris, HP-UX, IBM-AIX, Red Hat Linux, Windows NT GUI: Developer 2000 (Forms 4.5, Reports 2.5), Developer 6i (Forms 6i, Reports 6i) Database Tools: OEM, RMAN, Data Pump, Export/Import, SQL Loader, OWB, OID, ASM, Oracle RAC, Data Guard, Toad, SQL Developer, DPA

Miscellaneous Tools: BMC Patrol, Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Languages: SQL*Plus, PL/SQL, Unix Shell Scripting (csh, ksh, bash) Additional Skills: NoSQL, RAIK (Redundant Array of Independent Kernels) PROFESSIONAL EXPERIENCE

Liberty Mutual Finance Mar 2020 - Current

Oracle Database Administrator

Responsibilities:

• Provided 24/7 Oracle production database support for Oracle 10g/11g/12c/19c RAC and standalone databases.

• Implemented NoSQL database solutions (e.g., MongoDB, Cassandra) to support the storage and retrieval of unstructured data, improving scalability and performance for specific use cases.

• Configured and fine-tuned RAIK (Redundant Array of Independent Kernels) for efficient load balancing and fault tolerance, optimizing resource utilization and ensuring high availability in distributed computing environments.

• Managed and administered database systems as a DBA, including database installation, configuration, backup and recovery, performance tuning, and security management, ensuring optimal system operation and data integrity.

• Performed database design assessments with technical Product Owners to build and deploy standardized database solutions that meet business needs.

• Installed, configured, and maintained Oracle RAC and standalone databases.

• Installed and configured OEM Grid control.

• Installed and configured Oracle GoldenGate unidirectional and bidirectional replication.

• Upgraded GoldenGate from 12c to 19c.

• Managed, troubleshooted, and resolved Oracle database, RAC, and application issues.

• Involved in upgrade/migration of the Oracle database from 11g to 12c, 12c to 19c.

• Implemented high availability solution with Oracle 12c, 19c RAC, physical and logical standby, and replication using GoldenGate.

• Developed back-end logic for business applications, e.g., views, procedures, functions, triggers.

• Monitored/managed several RAC and standalone databases using OEM Grid control.

• Configured database backup using RMAN catalog database for full, incremental, and archive log backup.

Ameri Source INC Mar 2017 – Feb 2020

Oracle Database Administrator

Responsibilities:

• Created and set up Dev/TEST/QA environments from Production database.

• Upgraded and configured Oracle databases from 11g to 12c.

• Collaborated with cross-functional teams to optimize database performance and troubleshoot performance issues, utilizing advanced tuning techniques and tools such as Oracle Enterprise Manager and SQL tuning advisors.

• Implemented high availability and disaster recovery solutions, including database replication, failover mechanisms, and backup strategies, ensuring data availability and minimizing downtime in case of system failures.

• Installed, set up, and configured Data Guard.

• Cloned databases using scripts as well as RMAN.

• Wrote shell scripts for alerts for ORA errors, backup and recovery, import and export procedures.

• Managed user security, privileges, roles, auditing, profiling, and authentication.

• Extensively tuned database performance, including SGA tuning.

• Created and managed database objects, including tables, tablespaces, data objects, indexes, user logins, and passwords.

• Refreshed and replicated databases from production to testing using hot backup.

• Partitioned tables and created index-organized tables and locally managed tablespaces.

• Worked with blobs, clobs, materialized views, and bitmap indexes.

• Managed storage, including space, tablespaces, segments, extents, rollback segments, and the data dictionary.

• Installed and administered Automatic Storage Management (ASM).

• Involved in database designing and database architecture.

• Evaluated and researched hardware for Oracle RAC environment.

• Used Oracle Advanced Replication feature to set up multi-master replication.

• Conducted business impact analysis, developed recovery strategy, and planned testing and training for business continuity and disaster recovery plans. Education:

• BACHELOR OF SCIENCE WITH HONORS IN BUSINESS AND INFORMATION TECHNOLOGY

• Certification: OCA

• DIPLOMA IN BANKING AND FINANCE

• CERTIFICATE IN BUSINESS STUDIES

• HIGH SCHOOL DIPLOMA

Contact this candidate