Database Administration/Application Developer/Server Adminstration

James C. Beveridge

**** ********** ******* **********, ** 17111 717-***-**** *******@*****.***

US Army Veteran, accomplished Information Technologist and proven problem solver with 10+ years of experience, seeking senior level position with leadership potential involving architecting, maintaining, developing, and creating modern systems using database technology.

KEY QUALIFICATIONS

JOB CATEGORY

EXPERIENCE

Management

Interim Global Database Director (6+ months).

Managed four teams of application/database administrators supporting Oracle EBS; Oracle datawarehouses; Oracle, DB2 and SQL Server online transactional processing (OLTP) databases.

Designed, setup, managed, patched and maintained databases and related software (Oracle and SQL Server).

Built team to support Postgresql and continue support of DB2.

Database Administration

Designed, setup, managed, patched and maintained databases and related software.

Oracle (10+ years), SQL Server (10+ years).

Supported highly scalable, redundant and compliant databases (HIPAA, PCI, SOX, SSAE16)

Server Administration

Performed Unix/Linux server administration for database servers including security, patches and upgrades, software installation and backup and recovery.

dynix/ptx (1+ years), DGUX (5+ years), AIX (2+ years), Solaris (3+ years), Linux (1+ years).

Performed Windows server administration for database servers including security, patches and upgrades, software installation and backup and recovery.

Windows 2003/2008 (4+ years).

Performed Windows desktop administration (2+ years

Consulting

Required a government security clearance (has been inactive over two years).

Cloned Linux servers.

Setup and maintained database security on customer databases.

Setup and maintained database/application monitoring and alerting.

Designed, setup, developed, maintained Oracle datawarehouse and decision support databases at customer sites.

Setup and maintained ETL software for loading databases.

Designed, setup, developed and maintained Oracle APEX applications.

Oracle Exadata

Led effort to stabilize Oracle RAC

Diagnosed and resolved resource management issues

Drove changes to properly use flash cache and other Exadata features

Coordinated setup of Oracle Platinum Support monitoring and incident management

Requested application changes to better use Oracle Exadata resources

Application Support

Oracle Application Express/PL/SQL Cartridge (4+ years), Oracle Forms and Reports (8+ years), PL/SQL (10+ years), TSQL (4+ years).

SELECTED ACCOMPLISHMENTS

CSG International (formerly Intec Billing and formerly EUR Systems), Denver CO (10+ years)

Database Manager, November 2015 - March 2017

Managed two teams with as many as eight US based direct reports and functional management of eight global team members (teams provided support for five database platforms; Oracle, SQL Server, DB2 UDB, Postgresql and Oracle EBS used for 20+ application systems).

Annually decreased the frequency of team critical and high incidents by more than 50% by improving monitoring and alerting; working with application teams to improve testing and deployment methods; automating redundant changes; and standardizing maintenance procedures.

Annually decreased the duration of customer impacting incidents by 30% through more testing;improving documentation for fail-over procedures; and standardizing build, setup and maintenance scripts used for databases.

Transitioned support of over 100 SQL Server databases that service over 20 companies from the New Jersey support team to our team and decreased the number of incidents by 80% over the previous year.

Interviewed, on-boarded and supervised the knowledge transfer of two additional SQL Server DBA’s to make them effective in supporting the rest of the team.

Database Team Lead, November 2010 - November 2015

Built documentation repository for database/applications support and customer specific configurations and contacts.

Budgeted, planned and scheduled Oracle 12C class for 15 production and development DBAs, while still supporting on-call and project work, saved 65% of the cost by in-housing in the Denver office.

Documented and maintained procedures for common database administration tasks and changes.

Automated estimates for Full-Time Employee (FTE) requirements for new projects depending on the applications being implemented, the availability requirements and size and growth rates of the databases.

Coordinated specific database parameter changes and patching with CSG customers to resolve Oracle System Change Number (SCN) issues that could have caused an industry wide database outage.

Acting Global Database Director, December 2013 - April 2014

Reduced global database team wireless budget by 25% by reviewing bills and converting to cellular plans that offered more necessary services for less money and reducing the amount for features that were not needed.

Devised and implemented plan that used resources from other departments with specific skills to stabilize an unreliable Oracle Exadata environment.

Recruited, interviewed and hired three replacement DBA’s to rebuild a database team decimated by the loss of the three most experienced DBA’s on the team who exited the company over a couple of months.

Documented and recommended changes to an intense and time consuming application release process that took several days and nights straining database administrator resources, that was able to be changed to hours instead for the next quarterly releases.

Implemented documentation stores to capture knowledge so that processes and procedures are captured for repeating and knowledge retention even if an employee leaves.

Implemented subject matter expert (SME) primary and backup responsibilities for each supported application to improve accountability and accomplishments for individual DBAs.

Established global teams to provide off-hours support for our DBA teams.

Database Consultant, December 2011- December 2013

Resolved issue in Oracle Grid Control 12C that caused the SYSAUX tablespace to constantly grow

Automated data bulk load, data validation, data augmentation and data cleansing routines for meta-data and reporting databases.

Automated processes using schedulers, UNIX Shell scripts, PL/SQL scripts and error handling routines so that a DBA only needed to be on-site for database changes or irregular issues.

Database Administrator, February 2006 - November 2010

Re-coded TSQL replication jobs to improve reporting from error handling.

Led effort on network performance issue, worked with anti-virus vendor to collect virus symptoms and resolve major company wide virus.

Resolved performance issues on a SQL Server 2005 database to allow it to grow over the one terabyte threshold and grow to several terabytes.

Built out infrastructure to support databases for 60+ customers including monitoring, backups, data archiving and purging, tape retention and vaulting per customer contracts and application requirements.

Provided capacity and growth projections for existing customers and new projects.

EDUCATION

Bachelor of Science Degree, Clarion University of Pennsylvania, 12/93

Major: Computer Applications and Information Systems

SKILLS

Computer Languages:

SQL PL/SQL TSQL Bourne Shell Korn Shell BASIC Fortran COBOL RPG Pascal PERL VB

Software:

Windows XP through Windows 2008 Unix (DG/UX, dynix/ptx, HP-UX, AIX, Solaris, Linux) Access Oracle SQL Server Designer ERwin Developer/2000 Power Builder Business Objects Enterprise Manager SQL Server Remedy

PVCS Management Studio Informatica Jira Oracle Application Express (APEX)

Contact this candidate