Sql Server Manager

ADEKUNLE ISMAIL

Email: *******@*****.***

Phone: 678-***-****

EXPERIENCE SUMMARY:

Have over 8+ years of focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing. Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA; proficient in Oracle /9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 11g/10g/9i/8i/8.x/7.x on Unix and Windows NT platform. Involved with architect group in designing the logical and physical model of the databases. Thorough understanding of the Oracle data dictionary. Have good experience in UNIX administration, Shell scripting. Have impeccable communication and interpersonal skills and an exceptional team player. Managing the team of Oracle DBAs and actively coordinated with the end user community.

KEY COMPETENCE

ORACLE

Excellent experience and maintaining database including database security, Capacity monitoring and performance tuning (I/O, Memory & SQL Tuning etc.) Using Stats pack, Explain plan, Analyze, ADDM, AWR Report and so on.

Gathering and analyzing AWR report for troubleshooting purposes.

Implement Oracle Optimal Flexible Architecture on various platforms.

Implement various enterprise database backup and recovery using RMAN.

Extensive knowledge of golden gate installation and monitoring.

Strong emphasis on organization and documentations.

Excellent interpersonal and strong communication skills (including Presentations).

Customer-service oriented attitude and self-motivated, dedicated in any work environment.

Good experience in regular Security patching on oracle products and interim patching for various bug fixes on database products.

Good experience in regular Security patching on oracle products and interim patching for various bug fixes on database products

Great working experience in writing SQL for creating views, functions, stored procedures, creation of database etc.

Extensive experience implementing backup and recovery strategy for disaster recovery using Hot/Cold Backups and using the Oracle backup utility such as RMAN.

Experience in a variety of hardware platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX

Excellent knowledge of SQL*Plus, SQL*Net, SQL*Loader, Enterprise Manager & Performance Tuning Pack

Great working knowledge installing, patching, maintaining and upgrading all Oracle software (10g to 11g and 12c).

Extensive knowledge on database backup/recovery strategy (RMAN, Export/Import & Datapump), Capacity Planning, Oracle configuration management, Database Cloning, Refresh, and patch management.

Documentation of the work assigned in the environment and stored for the future use.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012.

Experience in Disaster Recovery Planning, Execution and Testing at remote side.

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008.

Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

ERStudio, Computer Associates Erwin, MicroStrategy DSS, Sagent Design Studio, Universal EDI, SQL/Transact-SQL

Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

UNIX

Install and configure SUN, HP, AIX Unix.

Upgrade and migrate UNIX versions and apply patches.

Partition raw and cooked devices and configure network file systems.

Reorganize file systems and reallocate disk spaces for better performance.

Implementing RAID technology using Veritas LVM and Solstice.

Schedule at and cron jobs to automate system administration routines.

Administer user accounts, file system security and user auditing.

Plan and perform system backup and recovery, both local and remote.

System administration, monitoring and performance tuning.

EDUCATION

Bachelors of Science in Computer Science

Olabisi Onabanjo University, Nigeria 2005 - 2009

Oracle 10g 11gR1, 11gR2, 12c

Oracle Certified Associate. 2014

Diploma Cert. in Graphics. 2005

EXPERIENCE

BANK OF AMERICA Aug 2014 – Till Date

Jacksonville FL

Role: Sr. Database Administrator

Responsibility

Working with other IT professionals for database designs and reviews, troubleshooting database issues and deploying timely fixes.

As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases at over 300 databases at Bank of America.

Mentor other DBAs in effective use of RMAN software, and my scripts.

Data center Migration using Data Guard.

Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM

Enforced need of regular data purging processes from production, design and development, to deployment.

Converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.

Strategic involvement with client for Server virtualization and manageability of infrastructure.

Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.

Maintaining regular and proactive for both OS and database patches, updates and performance enhancement.

Resolved and diagnosed rac node eviction.

Worked in 24x7 production environment and provided on-call and day-to-day support

Managing table spaces, data files, redo logs, tables and its segments in exatada env.

Migrated Non-ASM Single Instance to ASM RAC Instance.

Troubleshoot performance issues for the RAC instances (GC events).

Enhancing SQL statements performance using Explain Plan and Oracle optimizer hints.

Worked with customer for different RAC related issue :[hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on]

Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.

Experience with migrating SQL outlines to SQL plan baselines.

Experience with SQL Plan stability implementation using SQL plan baselines and SQL patches.

Administering and maintaining the company’s databases including daily monitoring and performance analysis using, ADDM, AWR Report etc. Gathering and analyzing AWR report for troubleshooting purposes.

Involved in configuration of parameter files for extract process in primary and replicat process in standby using Golden Gate.

Install and configure Golden Gate, trouble shoot Golden Gate and monitor replicate lag and check point.

Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability etc, Gathering of awr report, Online table redefinitions.

Replication of data using oracle goldengate utilities and Oracle Dataguard.

Implementing and configuring of standby database using RMAN active duplicate.

Setting up GoldenGate extracts/replicates and monitor the lag with automation.

Installing, patching, maintaining and upgrading all Oracle software (10g to 11g) and (11g to 12c) using DBCA.

Assists in the development of policies for data management pertaining to security, audit, privacy, and ensure these policies are complied with • Uses SRVCTL/CRSCTL utilities for managing multiple Oracle RAC instances and nodes.

Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.

Have hands on experience on ACTIVE DATAGUARD and SNAPSHOT STANDBY database.

Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

Hardworking with quality proven work ethics. Excellent interpersonal, communication, problem solving and analytical skills.

Managing different oracle database files across different file system like ZFS, DBFS and so on.

Worked on SQL tuning, SQL Profile and SPM package etc to optimize the query performance.

Worked on Oracle Enterprise Manager (OEM) for monitoring and maintenance of 12c, 11g, 10g databases.

Experience in Performance Tuning,Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, Tkprof, Analyze, ADDM and Explain Plan Methods.

Experience on Oracle Support Process for Technical requests using Metalink and other support procedures.

Alert log Monitoring for critical databases every day in the production environment.

Trouble shooting Database High load and Memory/Process issues.

Installation of RAC nodes from the Scratch and the maintenance of the high available Databases.

Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM's native rebalancing feature.

Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.

Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.

Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the ervers.

Performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem

Scheduled a regular hot backup process and involved the in the backup activities on crontab or autosys

Safeguarding data by instilling backup, managing user access and securing databases.

Implemented SQL Server based solution to consolidate dozens of scientific data collection and reporting applications.

Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.

Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.

Collaborated with faculty member, scientist and staff to design data intensive applications to capture, organize, analyze and report on data collected from scientific experiments and external sources.

Approved and ran scripts for Quality Assurance and Production releases.

Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.

GENERAL MOTORS Feb 2014 – May 2014

Alpharetta GA

Role: Lead Database Administrator

Responsibility

Installation of Oracle Software on all UNIX flavoured OSs.

As a Lead Database Administrator, I am Responsible for administration of over 150 Oracle databases.

Implemented Oracle Database 10gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.

Hands on experience on automatic storage management adding and dropping disks from diskgroup.

Resolved and diagnosed rac node eviction

Migrated Single Instance databases to RAC databases.

Managing different oracle database files across different file system like ZFS, DBFS and so on.

Experience in adding and removing nodes to RAC Cluster.

Database upgrades and migration of databases from 10g to 11g environments.

Performed various tasks on ASM, creating a disk group, Adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.

Experience with SQL Plan stability implementation using SQL plan baselines and SQL patches.

Provided production support, 24x7 on-call supports.

Built physical standby databases for RAC and standalone databases on Linux and UNIX platforms.

Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases.

Issues with block change tracking & also flash recovery area.

Hands on experience on Physical standby, active dataguard and snapshot standby databases.

Designed backup and recovery strategy using RMAN.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Used Expdp and Impdp for exporting and importing of database objects between databases.

Day-to-day Database administration activities like, table space issue, mount point space issue, high CPU utilization, locking/blocking sessions, etc.,

Involved in Application tuning using explain plan, SQL Trace, DBMS_STATS and ADDM.

Generated AWR reports, ADDM reports for fine performance tuning and worked closed with PL/SQL developers to tune TOP SQL running queries in databases.

Used AWR & ASH reports to view statistics regarding I/O Tuning, Memory Tuning, wait events, resource intensive SQL etc.

Used Invisible Indexes, and turn off indexes temporarily to check how queries perform without them.

Experience in unidirectional replication using GoldenGate.

Created User accounts, Roles and granting required access permissions and privileges.

Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc. Provided a 24hr on call production support.

Experience with migrating SQL outlines to SQL plan baselines.

Administered and maintained constant back up and archived data on tape.

Set up Active Dataguard Configurations for oracle database for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.

Monitoring the database performance using OEM Grid Control and Toad.

Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.

Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.

Managing table spaces, data files, redo logs, tables and its segments in exatada env.

Installed, configured, upgraded and migrated Oracle Database.

COIN GROUP LLC Aug 2008 – Jan 2014

Norcross GA

Role: Database Administrator

Responsibility

Installation and configuration Standby and RAC Database.

Up-gradation and Migration of Database from 10g to 11g and applying patches whenever required.

Experience with Oracle Supplied Packages such as DBMS_SQL and DBMS_JOB

Perform Backup and Recovery on Oracle databases.

Responsible for moving data from one database to other using Traditional Exp/Imp and Data Pump Export/Import.

Backup/Recovery of Oracle databases using Oracle RMAN.

Monitoring the database performance using OEM Grid Control and Toad.

Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.

Experience with migrating SQL outlines to SQL plan baselines.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR) and automatic database diagnostic monitor (ADDM).

Experience in Database Cloning and refreshing using Traditional Exp/Imp, Data Pump Export & Data Pump Import.

Scheduled a regular hot backup process and involved the in the backup activities.

Involved in Installation, Configuration and deployment of Real Application Clusters (RAC) on different nodes and experience in adding and removing nodes.

Managing two nodes Real Application Cluster databases on Red hat Linux

Database refresh from Production to Test as needed.

Working for Solution Support Center and resolving critical service requests related to RAC, Dataguard, ASM and other DB issues.

Experience with SQL Plan stability implementation using SQL plan baselines and SQL patches.

Hands on experience with performance issues spanning across multiple layers(Database, systems, applications and networking)

Monitoring of Listener and TNS names.ora files and storage space for better performance

Monitoring of tablespaces, indexes, memory and logfiles.

Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans.

Set up, configuration and maintenance of Standby Databases for disaster recovery, high availability and data protection.

Excellent performance of oracle database patches.

24x7 production support for several mission critical systems which utilize multiple Oracle databases.

Worked on import/export, export datapump/import datapump and SQL- loader.

Performed Health Checks for database auditing purposes to involve running scripts to gauge security exposures and subsequently implement resolution to violations.

Creating and managing the database objects such as tables, indexes and views.

Wrote SQL, PL/SQL programs such as functions, procedures, packages and triggers.

Managed the flashback space and performed recovery of dropped tables and data using flashback recovery.

FTL LIMITED. Jan 2005 – May 2008

Lagos Nigeria

Role: Graphic Design/System Administrator.

Responsibility

Design marketing materials for small business owners.

Import design campaigns through Facebook, Twitter, Instagram

Upload edited videos through YouTube, Facebook, & Twitter.

Extensive knowledge on usage of Corel Draw.

Design marketing materials for small business owners using Corel Draw, Adobe Photoshop.

Executed multiple digital marketing campaigns through tight deadlines.

Responsible for updating current news, as well as events in local areas on hand bills

Imported designed campaigns through social media platforms.

Extensive and adequate type setting using Microsoft word and excel

SKILLS PROFILE:

Hardware : SUN Sparc Series, HP9000, IBM 7040-681, IBM 9119-595, Pentium Servers

and PC's

Operating System: UNIX (SUN Sparc Solaris 2.6/2.7/2.8,9,10, HP-UX 9.x, AIX 5.3,5.2,5.1,4.3),

Windows XP/2000/NT/98/95

Tools / Utilities: DBArtisan, Erwin 3.5.2 /4.0 TOAD, SQL Station 5.0, Informatica 5.1,

Quest Soft ware Tools (Spot light, SQL Lab Vision, Storage and Performance Management) Recovery Manager, Tivoli ADSM version 4.21 for oracle on AIX, Veritas NetBackup (3.5,4.0,4.5) for oracle on Solaris and NT, DBverify, Exp/Imp, expdp/impdp, Server Manager, SQL * Loader, TKPROF, Log Minor, Statpack and Oracle Enterprise Manager grid control, AUTOSYS, ITSM, SQLT,Foglight,BDA

Languages : UNIX shell programming, PL/SQL

Database : ORACLE 11g/10g/9i on UNIX and Window platform

Contact this candidate