Senior DBA Resume NY - Hire IT People

SUMMARY:

Proven history of providing production support for critical trading, regulatory and surveillance databases. Great analytical skills to support the business - critical processes and day to day production issues and challenges.
Demonstrated proficiency in hardening security, maintenance and monitoring automation, performance and tuning, migrations to different platforms and upgrades.
Expert in Oracle, Sybase, MySQL, TimesTen (X10 in memory database), knowledge of Mongo - NOSQL database.
Customer oriented, team leader that excels at exchanging information and ideas with all team members, creating a shared sense of purpose and achieving organizational goals.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g|12c | Sybase 12.5 and 15 | IBM Netezza 7.2 | MySQL 5.6, 5.7 and TimesTen (in memory database)

Operating Systems: RedHat Enterprise Linux 4/5/6 | Windows NT/XP/7/10 | HP-UX 11 | Sun Solaris 5,6

Languages: PL/SQL | SQL | NZSQL | Transact-SQL | Shell scripting | C | C++

PROFESSIONAL EXPERIENCE:

Senior DBA

Confidential, NY

Responsibilities:

Providing 24/7 production support for critical trading, regulatory and surveillance databases, using ServiceNow for Incident & Problem Management. Expert troubleshooting problems and ability to analyze and resolve difficult technical issues quickly in a high pressure environment.
Design and implement Oracle’s High Availability (HA) and Disaster Recovery (DR) using RAC and Data Guard (Snapshot, Physical and Logical standby)
Worked proactively in collaboration with development team to monitor and tune the queries and detect the problem before it happens . Identify and troubleshoot poorly performing queries for Oracle, Sybase and MySQL trading database. Also help development team to migrate applications from Sybase to Oracle.
Lead database migration, tuning, optimization, and support efforts for Oracle RDBMS 10gR2, 11gR2 in enterprise environments. Also completed migration to Exadata Platform. Design and implement database security solutions, including Oracle database security option. Also migrated data from Sybase database to MongoDB.

Senior DBA

Confidential, NY

Responsibilities:

Consolidated standalone databases and improved performance while providing high availability by implementing Oracle clusterware and RAC with ASM for enterprise-wide databases.
Automated failover for critical trading databases by configuring VCS to work with VIP’s for Tidal Scheduler, enabling switching of all Tidal jobs once VCS detected a failure and switched over to live database.
Introduced global scripts monitoring and set up automated monitoring jobs for primary and standby sites, resulting in consolidation of monitoring into one common area that was easily manageable and modifiable including generating consistent alerts which were easy to understand and diagnose. Guaranteed database integrity by developing backup and recovery procedures using RMAN and data pump.
Improved business operations, eliminated failures, and complied with SEC regulations by installing, patching, and maintaining Oracle software on dedicated UNIX servers. Implemented Oracle fail-over technology using self-developed scripts and flashback technology for mandated quarterly SEC DR (disaster recovery) testing.

DBA

Confidential, NY

Responsibilities:

Enabled company to compete and lead industry through creation of faster and more reliable network connections for systems and customers, by migrating databases to new state of the art data center in Mahwah. Also upgraded to oracle 11g, Installed, patched, and maintained Oracle software while migrating. Migrated Sybase and MySQL databases, and upgraded where possible.
Implemented Oracle fail-over technology using self-developed UNIX shell scripts. Created scripts, permitting run of weekly and monthly reporting, enabling monitoring users’ profiles and ensuring all SEC security requirements were met and maintained.

Consultant-DBA

Confidential, NY

Responsibilities:

Maintained Surveillance and Regulatory and high impact listing databases for NYSE, resulting in improved performance and eliminated failures. Used Sybase replication, achieving high availability and maintaining database integrity. Provided maintenance scripts for backups and monitoring using Remedy system.
Worked on upgrading from Oracle DB to X10 (TimesTen - in memory database) for major trading system (Consolidated Broker System - CBS), used Times Ten replication, resulting in improved performance and user experience for trading systems and high availably.
Collaborated with FINRA DBA, moving regulatory databases to FINRA in very smooth and orderly transfer.