Sql Server Oracle

Mobile: 404-***-**** Email: ********@*****.***

https://www.linkedin.com/in/emmanueltannor

SUMMARY: Experienced Database professional with direct experience in Oracle, Ms Sqlserver. Installation, configuration, creation and upgrades in Oracle environments (10g/11g.12c) using OS via. Linux, UNIX and Windows XP/NT servers, database analysis of components and configuration of database migrations. Strong ability to implement migration, consolidation and upgrade strategies, which include source to target migrations and cutover. Fundamental understanding in Accounting, Finance,strong data analysis experience. Strong communication skills, and ability to effortlessly interface and build rapport with technical and non-technical users.

Skills Summary:

ORACLE 10GR2,11GR2,12C-

Database Administration – Oracle 10g/11gr2/12C.

Red Hat Enterprise Linux, Unix OS.

SQL and PL/SQL programming language – Stored Procedures,Triggers,Functions.

Knowledgeable in HA per Oracle – RAC configuration.

HA experience per Dataguard, Goldengate.

Database Tools: EM Dbconsole, Grid control, Sql Developer,Toad, RMAN,Putty, VPN.

Providing support to Oracle databases using Oracle Enterprise Manager Database control and command line tools utility like - Netca, DBCA, DBUA, OPATCH.

SQL developer.

SQL SERVER -

Windows Server 2008, 2008r2,2012 Enterprise/Datacenter.

Using Activity monitor, Performance monitor, and DMV’s to identify and reduce outstanding waits in SQL Server.

Installing, configuring, maintaining, and upgrading MS SQL Server 2005, 2008/2008r2 (Enterprise, developer, Express, Evaluation).

Knowledgeable High availability(HA), and Disaster Recover(DR) solutions including installing and configuring Windows/SQL clustering, Database Mirroring, Log Shipping, Replication.

Knowledgeable AlwaysOn availability groups(Sql Server 12)

Experience with setup and administration of SQL Server Database Security including implementing assigning privileges and roles in accordance with Principle of Least Privilege.

Data migration using Import/Export Wizard, BCP, Bulk Insert, OpenRowSet, SSIS, Export/Import wizard, and SSMA.

SSMS, SSIS.

Other Applications: Crystal Reports, Advanced Excel, Access.

PROFESSIONAL EXPERIENCE

MG NET LLC Atlanta, GA

Oracle DBA December 2011 – August 2016

Database upgrade – Data migration tools, upgraded 11g to 12c.

Part of DBA team managing 25 databases. This included 15 production databases and 10 development/test database's.

Installed and configured Oracle Goldengate Unidirectional Environment.

Installed and configured Oracle Data Guard.

Traced user sessions and utilized AWR/ADDM/ASH reports for tuning.

Utilized a variety of tools - OEM, RMAN, Data Pump, UNIX shell scripts – to backup, refresh/clone databases

Leveraged AWR/ASH/ADDM/ reports and OEM (SQL Monitoring and Tuning Advisor) to monitor and optimize poor performing reports

Routinely applied scheduled PSU/CPU and one-off oracle patches.

Created scripts for database monitoring using CRON Jobs.

Monitored databases, and tweaked parameters for performance tuning.

SQL and PL/SQL skills – worked with developers to fine tune queries.

Performed Hot/Cold backups & recovery using shell scripts and RMAN.

Created Sql Server Backups, Restored and Recovered System, Users, and TDE Databases in compliance to RTO and RPO.

Sql Server integrity checked. Methods include configuring Database maintenance plans, index maintenance, and DBCC Utilities.

Performed Sql server Tuning and Optimization (PTO) TSQL queries using native SQL tools like SQL Profiler, database tuning advisor, and third party tools like SQL Optimizer(Toad).

Used Activity monitor, Performance monitor, and DMV’s to identify and reduce outstanding waits in SQL Server.

Third Party Tools: SpotLite on SQL, Toad,Idera, SQL Sentry,PAL, Acronis

Provided 24/7 Support .

Environment: 90% Oracle 11g, 12c,,10% MS SQL SERVER 2008R2,11gr2, Linux(Redhat), Oracle GoldenGate and Dataguard, Datapump -Export/Import, OEM Dbconsole.

Jupiter Financial Services- Atlanta, GA January 2004 – July 2011

Data Analyst:

Prepared year-end financial reports, prepared net revenue and expenses report for various organizations.

Perform Gaap analysis on financial data ranging from overnight loans and float to outstanding mortgages.

Filed monthly sales, occupancy taxes and heavy phone contact with various state agencies to resolve delinquencies on behalf of clients.

Used advanced excel features (pivot tables, multiple linked sheets etc) to prepare spreadsheets.

Gathered data necessary to accomplish analysis from Access database,imported it into Excel for further manipulation using Excel functions e.g If Else if, Extract number,convert etc..

Converted flat text files from mainframe into excel format using excel functions feature.

Imported data from SQL Server into Excel using Import/Export Wizard.

EDUCATION:

Bernard Baruch College (City University of New York) – B.B.A Finance

Pacific Training Institute – Oracle 10gr2/ Sql Server 2008R2,2012 DBA

Professional Affiliation and Forum Support:

PASS (Atlanta BIDS group, Atlanta SQL users group)

SQL Skills (Paul Randall’s forum), SQL Authority (Pinal Dave’s forum)

http://www.dbasupport.com

www.sqlservercentral.com.

https://community.oracle.com

https://asktom.oracle.com

http://www.oracle.com/technetwork/index.html

http://www.orafaq.com/forum/

Contact this candidate