Sql Server Oracle

OBJECTIVE

Contribute to the organization as a Database Administrator, Team Lead/IT Manager

Over 20 years of experience in Oracle Database/EBS administration & over 13 years SQL Server administration. Implemented Oracle and SQL Server Replication, SQL Server DB Mirroring and clustering. Performed Database Designing and Software Development, analyzing manual systems for automation as a Systems Analyst. Implemented Disaster Recovery systems/methods for major installations. Configured hardware/OS systems, Databases, Tools and 3rd party software.

Experience in Banking & Financial industry, Stock Trading, Manufacturing and Distribution and Health Care fields.

Collaborative and results oriented team player/leader with extensive customer/end user relations, experience and proven ability to communicate with peers and upper management extremely well.

TECHNICAL SKILLS

Databases:

Oracle 8i (and earlier versions), Oracle 9i, 10g and 11g with RAC, DataGuard Setup, RMAN and Advance Replication Option.

SQL Server 2000 to 2014. SQL Server Data Mirroring, Clustering High Availability Solutions.

Hardware/OS:

Linux 5.x to 7.x SUN Servers with Solaris 7 to 10, SUN StorEdge® Arrays and QLogic SANs, HP 9000 with HP/UX OS, DEC Alpha with OSF OS, Compaq (DEC) Tru64 including the Wildfire, IBM RS/6000 with AIX, MS Windows Servers, WANG VS, DEC VMS.

Development/Admin Tools/ Languages:

ORACLE® Designer/2000, ORACLE® Developer/2000, Oracle Enterprise Manager (OEM) Oracle Utilities (Import/Export, SQL*Loader, RMAN, Data Pump). Oracle Apps “AD” Utilities. Oracle Statspack, For Unix TOP. SAR and Proctool. Hot and cold backups. Writing T-SQL, PL/SQL Stored Procedures/Packages and DB Functions. Unix shell scripting. SQL Server Management Studio. SQL Profiler. ERWin, Power Designer designing tool,Oracle CASE Tools.

Major Applications:

Oracle Apps 11.5.x, BaaN ERP, PeopleSoft, Oracle Applications and customized applications for accounting, Stock trading Stock backend and front-end software, Broker software (Backend and Front-end). Data Warehouses/Marts, Fundtech- PayPlus USA and GPP (Global PayPlus) application development and support. TIBCO & UL Link Software. Reuters Goldtier Software for Foreign Account Tax Compliance Act (FATCA). Software for Dodd–Frank Act. MS Dynamics SL and GP.

EXPERIENCE

Database Administrator (Apr ’12 to Dec’16)

Santander Investment Securities/Produban New York, NY

Installed, upgraded and patched Oracle & SQL databases (SQL Server 2000 to 2014 & Oracle 9/10g/11g) in production, UAT and development environments using RedHat and Windows Servers.

Implemented Oracle Data Guard/SBDB for failover and RMAN for backups.

Implemented SQL DB Mirroring HA Solutions.

Performance tuning on Oracle and SQL databases and application code.

Installed, configured & monitored following software & middleware: ULBridge (ULLink) Goldtier (Thomson Reuters) and TIBCO. Connecting clients through ULBridge to Fidessa.

Configured Websphere 8.5 clustering.

DBA for MS Dynamics SL 2014 deployment/migration project, including user testing.

As a member of the product implementation committee, collaborated with developers and testers for testing and production deployment requirements.

Maintained 100% uptime on systems I was responsible for within the past 3 years.

Wrote UNIX Shell scripts to monitor and maintain backend database servers.

On call 24x7 and remote support for the operations team.

Senior Database Administrator (Apr ’08 to Apr’12)

D+H (Formally FundTech Corporation), Jersey City, NJ

Supported PayPlus & GPP software development teams in Oracle 9i/10g/11g and SQL Server. Developed stored procedures and triggers. DB upgrades and migration.

Production Application/Database trouble shooting and support for customers.

Tested FundTech PayPlus USA & GPP application. Configured Oracle10g RAC for GPP application & maintained Oracle 10g RAC Environments.

Implemented & tested SQLServer HA solutions (DB mirroring & Replication).

Configured and scripted RMAN for backups.

Upgraded and patched Oracle and SQL Server Databases.

Wrote data migration utilities in PL/SQL, T-SQL to migrate legacy systems at customer installations. Handled Tera byte size database migrations.

UNIX Shell scripting for application and environment maintenance.

Designed & Maintained DB structures using Power Designer.

Recommended new Oracle features to the developers for product improvements.

Oracle Financials DBA(EBS)/Oracle DBA (Apr ’02 to Apr’08)

Greater NY Hospital Association, New York, NY

Administered Oracle Databases including upgrades and migrations.

Technical Analyst/Admin for Oracle Applications 11/11i modules GL, AR, AP, FA, CE.

Migrated Oracle Apps 11.0.3 to 11i Rel.7/8/9 (11.5.7 to 11.5.9)

Migrated Oracle RDBMS 8i to 9i Rel.2.

Project Manager for all Oracle upgrade and migration projects.

Planned and implemented backup and disaster recovery strategies.

Managed MSSQL Server databases for in house applications.

Helped migrate Oracle Financials to MS Dynamics GP.

Re-implemented Oracle FA and implemented CE for the accounting Dept.

Customized Oracle reports using Developer/2000 Forms and SQL Report.

UNIX Shell scripting to monitor and maintain backend database servers.

Systems Administrator for SUN Solaris (UNIX) systems. Configured Sun Solaris systems for Oracle. Installed and configured SUN StorEdge® Disk Array systems.

Maintained SunFire 280R, SunFire V490, A1000 StorEgde and QLogic SAN systems for Oracle.

Maintained zero downtime for 4 consecutive years in the production environment.

Oracle DBA (Apr ’01 to Apr’02)

SPX Corporation Data Center, Horsham, PA

Administered Oracle 7.3, 8i and 9i databases for PeopleSoft HR, Oracle Financials and BAAN ERP software.

Monitored and tuned databases for better performance using Oracle OEM, TKPROF, StatsPack etc.

Supported developers/testers with database activity. Cloning large databases for developers and testers.

Migrated Oracle 7.3.4.4 and 8.0 databases to Oracle 8i Rel. 3 for PeopleSoft, BaaN ERP, Oracle Financials and various other in-house applications.

Administered VLDB, data warehouses Hot (Live) backups on production systems.

Design team member of a Data Warehouse/Mart.

Oracle SQL and UNIX shell scripting for monitoring.

Lead Oracle DBA (Nov ’99 to Feb’01)

LivePerson Inc., New York, NY

Lead Oracle DBA. Involved in installing, capacity planning & configuring Oracle 8i database for an online customer service application on SUN Solaris Environment.

Wrote PL/SQL packages and Database Triggers to migrate from SQL Server 7 to Oracle RDBMS 8i using the SQL Server Linked Server.

Configured Oracle Replication to transfer data to a reporting environment.

Designed Data marts and logical DB designs using ERWin software.

Oracle DBA (May ’99 to Nov’99)

Health Insurance Plan of NY, New York, NY

Worked as the Lead Oracle DBA in a PeopleSoft Financials/HR implementation. Wrote interfaces between Third party software (Kronos Payroll Management) and PeopleSoft HR using PL/SQL and Oracle Utilities (SQL*Loader, Imp/Exp).

Implemented user security in PeopleSoft.

Oracle DBA (Mar ’99 to May’99)

Transamerica Technologies Corp., Los Angeles, CA

Oracle DBA for Ver 7.X and 8.X databases. Implemented Oracle Advance Replication.

Created new database instances for development and testing & development.

EDUCATION AND TRAINING

Oracle10g Database Admin Part 2: Oracle Corporation (Mar ’08).

Enterprise DBA Part 2: Performance and Tuning The Complete Course Oracle Corp. (Nov- ’00).

Workshop in Leadership Management Skills Development conducted by The South Eastern University of Sri Lanka and Institute of Leadership & Management, Lahore (Pakistan) (May-‘98).

Oracle7 Symmetric Replication (Oracle Advance Replication Option) at Oracle San Francisco Education Center (Jun-‘97).

System Design & Generation with Oracle CASE conducted by Oracle Corp. UK. (Jul-‘93).

System Modeling with Oracle CASE conducted by Oracle Corp. UK. (Jul-‘93).

Diploma in Computer Systems Design conducted by National Institute of Business Management, Sri Lanka (Nov-‘90).

Diploma in Business Electronic Data Processing conducted by Institute of Business Electronic Data Processing, UK. (Nov-‘89).

AWARDS & HONORS

Outstanding Performance Award for Oracle Technical Support for the ‘94-‘95 Financial Year by the Board of Directors of DMS Software Technologies, Sri Lanka.

Outstanding Performance Award for Special Projects / Building New Business for the ‘92-‘93 Financial Year by the Board of Directors of DMS Software Technologies, Sri Lanka.

Contact this candidate