Vp, Architect Lead Resume
Brooklyn, NY
SUMMARY:
- Senior Oracle and Sybase DBA with experience in Financial Services Industry, providing IT solutions and problem resolution.
- Customer - focused with ability to see all aspects of each project. T
- Thrives in fast-paced environments, simultaneously handling multiple assignments and meeting deliverable dates.
- Detail-oriented with excellent investigative, problem solving, information gathering and troubleshooting skills.
- Self- learner, consistently building skills and best practices.
TECHNICAL SKILLS:
Oracle 11i, 10g, 9i | Oracle Data Guard | Oracle RAC | Oracle Golden Gate: Performance/Tuning, Oracle Upgrades 9i to 10g, 10g to 11i & Patching, Migration of databases from Solaris to AIX, using Oracle Datapump; Worked directly with Oracle Level 3 to resolve major issues, Backup & Recovery using RMAN, ASM Installation & Administration; Interpretation of Performance ADDR Reports from AWR, Creation of Instances, Tablespaces, tables, user, roles, indexes, profiles
Sybase 15.5 | Sybase Rep Server: Upgrades/Patches to Sybase Software, Performance and Tuning, DBArtisan used for monitoring Performance, Backup/Recovery using Confidential - SQLbacktracker, Creation of Servers, Databases, Indexes, tables, users
SQL Server 2008: Replication to Oracle database, Back-up and restores, SQL Tuning
Marklogic 8: Patching, SPARQL Tuning, Backups and Restores
No Magic MagicDraw | No Magic Teamwork: Modeling of Databases in UML, Vendor Management, Backup of Teamwork, Patching, installing, User Creation, model framework creation
Operating Systems: AIX, Linux, Solaris, Windows
Scripting: Unix KSH, BASH, PERL, PL/SQL
PROFESSIONAL EXPERIENCE:
Confidential, Brooklyn, NY
VP, ARCHITECT lEAD
Responsibilities:
- Worked with Agile Software Methodologies on all projects while at JP Morgan Chase using JIRA
- Patched/Installed and Performance Tuned Marklogic on Linux
- Wrote Sparql queries for reporting on Central Repository
- Designed new 3-machine system for No Magic’s Teamworks to remit major audit issues including not having a contingency setup in place for production data, no change control process, and no test environment for new releases of software Managed project for installation of the new 3-machine design
- Wrote purchase orders for new machines, purchased licenses from vendor, requested that systems administrators build new machines with specific requirements, installed software on Linux machine, and moved users from old machine to new machine
- Registered Open Source programs in the JP Morgan program repository allowing versioning consistency
- Microsoft Excel was used to identify users required to move to new virtual platform and then used to track project completion
- Vendor Manger for No Magic MagicDraw and No Magic Teamwork
- Installed/patched MagicDraw Software, which fixed latency issue, increasing performance by 50%
- Consulted with Information Architects to expand Banking “Fortress” model, for Payments and Liquidity.
- Managed project, gathering 10 samples from Payment Application for 200 payment flows, confirming no payment changes were made from beginning-to-end. Received Corporate Investment Bank (CIB) Individual Quarterly Achievement Award for project
Confidential, New York, NY
VP, Database Administrator
Responsibilities:
- Supported regular Contingency of Business with Auditable acceptable results
- Used Confidential Sqlbacktrack for all Sybase Database backups/restores
- Supported Oracle 11i, 10g, 9i on operating systems HP UNIX, AIX, and Solaris
- Led and trained remote team in India on company’s best practices; Worked 24/7 on production support
- On-boarded new applications working on team of Applications Managers, Systems Administrators, Network Engineers, Developers. Applications were both Confidential written and vendor owned
- Installed Oracle Golden Gate for replicating to a Sybase Server
- Second support on SQL Server 2008 Applications for both Treasury and Compliance; Tuning of SQL using OEM and HOTSOS
- Worked with Global Database Team on Install of Confidential Patrol for monitoring of all Oracle, Sybase and Sql Server 2008
- Upgraded Sybase Application from 12.5 to Sybase 15, moving from HP platform to AIX: completed ahead of deadline
- Wrote Unix Scripts to start and stop of Oracle instances and Sybase databases, backup databases, check space, run statistics, restore databases, check if data guard synchronized
Confidential, New York, NY
AVP - Database Administrator
Responsibilities:
- Primary DBA on Oracle and Sybase Database for Financial Reporting Systems, Anti-Money Laundering, Credit Risk Applications.