We provide IT Staff Augmentation Services!

Sr. Database Developer Resume

SUMMARY:

  • 15 years of Professional experience working in the capacity of Sr. Database Developer, Application DBA / Performance Tuning Specialist and SQL Engineer. Participated in all phases of software development.
  • Sybase ASE, Sybase IQ, MS SQL Server, Oracle, T - SQL, PL-SQL, DB-Artisan, Rapid SQL.
  • Database Tool development (Data archival, Database compare).
  • Shell & PERL scripting.

AREA OF EXPERTISE INCLUDES:

  • Database Development and General Administration.
  • Extensive Experience in Performance Tuning (batch processes).
  • {SQL | Database | Server} tuning.
  • Index {Design | Restructuring | Optimization}.
  • Converted serial processes into parallel.
  • Cache partitioning, Performed volume test.
  • Extensively developed Stored Procedures and Triggers, created data feeds.
  • Developed automated batch processes through Shell / Perl Scripting.

TECHNICAL SKILLS:

Databases: Sybase ASE 15.0.3/12.5.3 /12.5.0.3/12.0/11.9.2/11.5.1/10 , Sybase IQ 15.2.0/12.6 SQL Server 2008/2000, Oracle 10g/8, MS-Access 2000/97

Database Tools: DB-Artisan 9.1.2/8.5.5/8.0.1 , Rapid SQL 7.4/5.7, Sybase Central 4.1.1, SQL-Advantage 3.0

ADS 10.0, BCP, I: SQL, APT 5.3, DWB 5.2, SQL-EM, DTS, Query Analyzer, Profiler, Optdiag, re-org, sp sysmon

Languages: C, C++, PERL 5.0, XML, T-SQL, PL/SQL

ETL: Perl 5.0, Informatica

Operating Systems: Sun Solaris 10/8/7, HP-UX 11.0/10.0

Data Modeling Tools: ERwin 3.2, Power Designer 11.0

SCM: ClearCase, CVS, Opsware, SCCS, PVCS merant 6.8, VSS

Batch Scheduling: Autosys 11.0/4.0, Control - M, cron

Others: Mantas Trading Compliance 4.2, Platform Symphony, CBB Grid EnvironmentCrystal reports 9.0, Visio 2000.

PROFESSIONAL EXPERIENCE:

Sr. Database Developer

Confidential

Technical: Sybase 15.0.3, 0, DB- Artisan 9.1.2, T-SQL, BCP, Korn shell scripting, Autosys 11.0.

Responsibilities:

  • Worked on a strategic three-way reconciliation between ICEView, CVA Trader and GSL systems.
  • Worked on data masking using in-house provisioning system - Alcazar.

Sr. Database Developer

Confidential

Technical: Sybase 15.0.3, SQL Server 2008, DB-Artisan 9.1.1, T-SQL, I-SQL, BCP, Solaris 10, Korn shell scripting, Autosys 11.0.

Responsibilities:

  • Evaluated and wrote proposals for improving Firmwide Stress Initiative (FSI) module's performance/resiliency.
  • Optimized FSI module run time from 3 hours to 1.2 hours.
  • Develop data validation scripts for SPAR data warehouse.
  • Defect Management and Ongoing enhancements.

Sr. Database Developer

Confidential

Technical: Sybase 15.0.3, Sybase IQ 15.2.0, ADS 10.0, T-SQL, I-SQL, BCP, Solaris 10, Korn shell scripting, Control - M.

Responsibilities:

  • Data Center Migration (MRO to RTP): This project was intended to move ITIS data warehouse from MRO to RTP. Tested batch jobs and certified reusults. This effort enabled annual savings in maintenance costs, while increasing capacity and disaster recovery capabilities.
  • Evaluated and wrote proposals for improving Firmwide Stree Initiative (FSI) module's performance/resiliency.
  • Optimized FSI module run time from 3 hours to 1.2 hours.
  • Added ‘data transmission’ validation check to critical feeds as part of an internal audit requirement.
  • Created tables and set up feeds (ASE / IQ) for RouteHub, TwoFour and PreClear.

Sr. Database Developer

Confidential

Technical: Sybase 15.0.3/12.5.3 , Oracle 10g, SQL Server 2000, DB- Artisan 8.5.5, T-SQL, I-SQL, BCP, Stored procedures, Solaris 10/7, Perl, Korn shell scripting, Control -M.

Responsibilities:

  • Rebuilt highly fragmented indexes on the development databases and convinced Manager that application needs a periodic index rebuild (on most actively used indexes) and coordinated production implementation with the DBA team. Recovered 35 GB of free space from index rebuilt and thus batch cycle improved by 2.5 hours and weekly database maintenance improved by 2 hours.
  • Worked on database violations generated due to objects having public roles in production databases as part of SOX compliance. Analyzed current roles and permissions and wrote unix scripts for revoking public access from Americas, Europe and APAC region databases and ensured that all database objects have appropriate permissions.
  • Optimized price testing, data upload and mapping modules for product controllers. There is 65% improvement in the run time from 40 minutes to 14 minutes.
  • Implemented HUGO product code expansion (data type change), an enterprise-wide effort.
  • Enhanced stored procedures for fair value accounting.
  • Extensively worked on data archival and purging.
  • Provided nightly batch support for GPT/SPARTA applications.
  • Architect
  • Architect the development environment for offshore team and handled critical issues such as data masking of sensitive information such as counterparty information.
  • Implemented DOL schema for high traffic tables to improve concurrency and minimize deadlocks/ blocks.
  • Tool(s) - Data Archival
  • Developed a versatile data-archival tool, which archives data to an archival database over the weekend as a part of the weekly database maintenance schedule.
  • Added functionality to fire a threshold to clear the transaction log to ensure that data archival/purging runs smoothly.
  • An automatic ‘update statistics’ will run to ensure that distributions of key values have been updated.
  • A detailed process log is logged into a audit table.

Application DBA / Performance Tuning Specialist

Confidential

Technical: Sybase 12.5.3, Sybase Central 4.1, T-SQL, BCP, C++, Solaris 7, Korn shell scripting, Platform Symphony, CBB Grid Environment, ClearCase.

Responsibilities:

  • Identified and optimized SQL statements in stored procedures and reports. There was a 35% improvement in the critical path stored procedures and 53% improvements in the reports.
  • Converted report SQL’s into stored procedure call to avoid making repeating connections to the database.
  • Converted clustered indexes on temp tables in stored procedure & report SQL’s to non-clustered indexes to improve performance.
  • Recommended DBA team to increase user log cache (ULC) from 2k to 8K (based on the observation that transactions started taking upto 14 minutes while doing a commit). Change was implemented and transactions started committing at normal pace.
  • Optimized stored procedures for Basel Allocation module.
  • Fine tuned the logic to allocate CPUs to various tranches based on number of paths/deals for load balancing as follows:

Application DBA / Performance Tuning Specialist

Confidential

Technical: Sybase 12.5.3, Power Designer 11.0, DB- Artisan 8.0.1, SQL Server 2000, T-SQL, CT-Library, Informatica, Solaris 7, Perl, Autosys 4.0, DTS, JIRA, CVS, Opsware.

Responsibilities:

  • Changed high traffic tables from APL to DOL to improve concurrency and minimize blocks/deadlocks. A 40% performance gain was observed. This also helped in recouping 32% disk space.
  • Reengineered batch cycle jobs to make them run in parallel.
  • Identified SQL statements that were pain points and improved performance by altering SQL statements appropriately.
  • Created indexes as required, restructured indexes with poor selectivity.
  • Modified SQL queries to avoid deferred updates, Factored SQL queries for performance improvement.
  • Changed SARGS to accommodate query optimizers to use the best query plan using indices.
  • Modified specific stored procedures producing highly volatile data with ‘with recompile’ to avoid using a cached procedure plan.
  • Created shell script & stored procedure to load security ratings feed and scheduled it in the batch cycle using autosys.
  • Coordinated with SA’s for a largefile safe patch for receiving feed files bigger than 2GB.
  • Created data filter criteria & mappings using Informatica for various transformations such as ‘Credit Calculation’ and ‘numeric conversion’.
  • Provided production support and coordinated support with offshore team.

Sr. Database Developer

Confidential

Technical: Sybase ASE 12.5.0.3, Sybase IQ 12.6, Rapid SQL 5.7, Dbisqlc, Sybase Central 4.1, Mantas 4.2 (Trading Compliance), Hyperion Performance Suite 8.3, SQR, T-SQL, BCP, Solaris, Perl, Autosys 4.0, JIL, SCCS.

Responsibilities:

  • Sybase ASE 12.5.3 to IQ 12.6 Migration
  • Migrated ASE objects (procedures, triggers, tables, Indexes and views) to Sybase IQ.
  • Worked with DBA's to create users/groups and grant appropriate permissions.
  • Wrote load scripts to migrate data from ASE to IQ and performed load performance analysis.
  • Mantas Trading Compliance
  • Mapped firm’s order/trading/execution data obtained from various order and trade processing systems.
  • Created scripts to validate Trade and Market data.
  • Configured scenarios in Mantas.
  • Wrote scripts to massage data feeds and fed them into Sybase IQ/Oracle databases for alert generation.
  • MSDB Production Support & Maintenance
  • Designed tables, wrote stored procedures to setup Order Audit and Trailing System (OATS) feed (Included New, Cancelled and Corrected Orders) for Regulatory Reporting for NASD traded securities.
  • Setup feeds for High Frequency Trading (HFT) and easy to borrow list.
  • Participated in DR tests and performed checkouts to ensure that applications are working as expected.
  • Created script for archiving feeds and deleting log/temp files older 30 days older and job scheduled in autosys.
  • Provided nightly batch support that includes diagnose and resolve issues (e.g. Bad feed | File no show/Delayed | Deadlocks) to ensure that batch cycle finish at a decent time and SLA’s are met.
  • Developed Perl scripts for data extraction/transformation and load (ETL).

Hire Now