We provide IT Staff Augmentation Services!

Senior Database Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • I assist my clients by delivering high performance data solutions utilizing Confidential SQL Server.
  • Capable of most technical functions on this platform, I can provide business intelligence development, design and implement database enhancements, provide on - call administration and support, and staff up to speed on this technology quickly and effectively.
  • I learned my trade trial-by-fire directly from the designers of SQL Server and some of the best support engineers in the industry.
  • I have worked in large scale mission-critical production environments for over a decade, interacting directly with development and business teams to accomplish the real goal: making business thrive through technology.
  • My skill set is a result of innate talent combined with rare learning opportunities, a cut above what most database engineers on the market can offer.
  • I will improve the database schema and system architecture to enhance performance, deliver processes and automation to reduce the daily workload, mentor and train staff on best practices, and develop tools to provide your business more insight into existing data.
  • I will make the database work for you, instead of the other way around.
  • 9+ years designing and maintaining multi-terabyte SQL Server applications
  • Direct experience with some of the most complex environments in the world
  • A variety of projects with many clients, all with different goals, requirements and constraints
  • Wide exposure to heterogeneous platforms and third party applications

SKILLS AND TOOLS:

Database Technologies: T-SQL, Database Design, SSIS, SSAS, SSRS, ETL, SQL Server

Other Technologies: Windows Server, IIS, Epiphany, PeopleSoft, Java

Business Processes: SDLC, MSF

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Developer

Responsibilities:

  • Take over development/administration of poorly performing mission-critical executive level reporting application
  • Complete overhaul and redesign of existing application from 3/11 - 8/11
  • Reduce ETL time by over 90%, from 18 hours to less than 1 ½
  • Provide simpler, robust design that allows easier feature implementation
  • Simplify ETL processes and improve overall performance
  • Implement automation and self-healing administrative processes
  • Translate complex business requirements into technical specifications
  • Technologies: SQL Server 2008 R2, SSAS

Confidential

Senior Database Developer

Responsibilities:

  • Take over application development of project that was running up against a deadline
  • Troubleshoot and rapidly develop solutions for requirements missed during design
  • Facilitate rapid feature development, coordinating with offshore teams
  • Build application within complicated black-box framework
  • Develop according to complex policy requirements and organizational challenges
  • Retrofit new ETL and schema requirements into existing code base

Technologies: SQL Server 2008, SSAS

Confidential

Senior Database Consultant

Responsibilities:

  • Engaged Giftcard vendor to guide proper implementation of new features
  • Corrected debilitating performance issues with Loss Prevention application
  • Implemented performance enhancements on website to allow transaction completion
  • Implemented a number of audits and security measures to meet PCI compliance
  • Educated team on SQL 2008 features and licensing requirements

Technologies: SQL Server 2008, SSAS

Confidential

Database Architect

Responsibilities:

  • Modeled data warehouse and OLAP schema, including MDX expressions and logic
  • Modeled architecture for retrieving data from various networks and applications and reconciling information
  • Designed and developed ETL process using stored procedures and SSIS

Technologies: SQL Server 2008, SSAS, SSIS

Confidential

Senior Database Engineer

Responsibilities:

  • Planning and management of application rollouts coinciding with real-world events
  • Provide consulting services to development teams on database and query design
  • Re-architect permissions and logical server architecture, implementing virtualization
  • Maintenance and support of multiple revenue generating OLTP systems

Technologies: SQL Server 2008, SSAS, SSIS

Confidential

Database Architect

Responsibilities:

  • Modeled data warehouse and OLAP schema, including MDX expressions and logic
  • Designed and developed ETL process using stored procedures and SSIS
  • Normalized data feeds from multiple servers consisting of 20-40M rows per day
  • Designed and developed SSRS reporting components

Technologies: SQL Server 2005, SSAS, SSRS, SSIS

Confidential

Database Architect

Responsibilities:

  • Gathered throughput requirements and reconciled them with problem areas
  • Designed and implemented significant database and application architectural changes
  • Worked hand-in-hand with application vendors on performance enhancements
  • Educated application developers on leveraging SQL 2005 features
  • Successfully deployed application ahead of schedule and with significant cost savings

Technologies: SQL Server 2005, C# .Net

Confidential

Database Architect

Responsibilities:

  • Assessed undocumented DB2 application environment for design requirements
  • Implemented SDLC methodology for change management
  • Modeled SQL Server schema for equivalent functionality
  • Scoped, ordered and coordinated deployment of SQL Server hardware
  • Designed and configured migration and cut-over
  • Redesigned automation processes using Control-M software
  • Designed SSIS and Tibco synchronization process back to mainframe layer

Technologies: SQL Server 2005, SSIS, DB2

Confidential

Database Engineer

Responsibilities:

  • Consulted with developers and business on data warehouse development
  • Supported and maintained warehouse applications and corporate databases
  • Upgraded dozens of databases from SQL Server 2000 to SQL Server 2005
  • Supported and maintained Analysis Services cubes

Technologies: SQL Server 2000/2005, DTS/SSIS, SSAS, MOM

Confidential

Database Engineer

Responsibilities:

  • Designed SQL Server components for migration of high-availability OLTP Sybase application
  • Coordinated procurement and deployment of SQL Server hardware
  • Implemented replication from Sybase to SQL Server
  • Worked closely with application teams to coordinate application failover
  • Extremely successful deployment with minimal downtime and enhanced supportability of revenue generating application

Technologies: SQL Server 2005, Sybase 6.5

Confidential

Senior Database Administrator

Responsibilities:

  • Acting lead for completely new DBA team for backoffice support
  • Perform damage control and repair relations with reluctant business customers
  • Reviewed and streamlined onboarding and support procedures, removing barriers and emphasizing the partner relationship with the business
  • Consolidated multiple end-of-life servers onto newer and more efficient ones
  • Upgraded dozens of databases from SQL Server 2000 to SQL Server 2005
  • Implemented and supported Reporting Services frontends and reports

Technologies: SQL Server 2000/2005, SSRS, Sharepoint, PeopleSoft, Hyperion

Confidential

Database Architect

Responsibilities:

  • Lead a team of three production DBAs, mentoring and delegating responsibilities
  • Worked closely with developers to focus on performance and stability of the end product
  • Designed and implemented stored procedure and database schema enhancements
  • Scoped and procured network bandwidth for outbound mail traffic
  • Scoped and procured all application hardware
  • Designed and implemented all disaster recovery, automation and monitoring

Technologies: SQL Server 2000, Epiphany, Weblogic, J2EE

We'd love your feedback!