We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

3.00/5 (Submit Your Rating)

Warren, NJ

TECHNICAL SKILLS

OS PLATFORMS: AIX, RedHat Linux, Solaris, MS

SOFTWARE: SYBASE ASE 11.x, 12.x, 15.x, 15.7, ASE Rep Server, Sybase IQ 12.6, 15.4, 16.0 Multiplex, MS SQL Server 2008 R2, MongoDb 2.6, Oracle 9i

Modeling& ETL: Power Designer, Cayenne, Erwin/ERStudio, SSIS

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Senior Database Administrator

Responsibilities:

  • Server builds, maintenance and performance support for SAP/Sybase IQ Multiplex, Sybase ASE on up to 18TB of data.
  • Develop, script and implement multiple environments for Contingency server Disaster Recovery. operations using ksh, sh, Perl (log shipping, replication).
  • Stored procedure, bcp and cursor troubleshooting - and configuration changes where needed, to resolve response time and performance issues.
  • Work with multiple end-users to resolve Client application configuration and permission issues.
  • Performance tuning for several hundred developers and parameter changes as necessary for performance gains.
  • Installs and upgrades including custom one-off fixes from vendor.
  • Formulation and implementation of security policies, rules and access controls.
  • Procedural documentation for migrations, upgrades and troublshooting steps.
  • Lead many efforts with System Administration and SAN/Network Support to resolve HW problems.
  • Benchmark testing of new servers and tracking to resolution of SAN performance issues.
  • Creation (and migration) of DTS packages and OLAP cubes with problem resolution on mutiple levels.
  • Capacity planning and storage optimization for several dozen environments.
  • Developed Apache web-site with stored procs, scripts to display reports after polling servers for regular status, user activity and growth sending alerts to developer managers as well as alarms for DBCC issues.
  • Resolved or coordinated fixes for numerous SQL Backtrack/Netbackup issues.
  • Database ER modeling and reverse engineering for logical and physical changes and migrations.

Confidential, NewYork, NY

Sybase DBA Manager

Responsibilities:

  • Provide lead production/development Sybase DBA and UNIX shell scripting support for Republic National Bank General Ledger and Budget Operations departments. Included is support for GEAC SmartStream suite of Databases on several Enterprise servers
  • Logical and Physical Design on 4 Sun servers running 11.5.1
  • Migrated 4 servers from 11.0.3 to 11.5 & SOL 2.61 as well as Y2k compliance verification
  • Created k/cshell scripts to manage dbcc checks, tran.logs and nightly dbase dumps/loads for all servers
  • Wrote formal disaster recovery bank plan and operations guide for new servers
  • Attended Sybase 11.5 sys admin course
  • Attended Oracle 8.0 database admin course

We'd love your feedback!