We provide IT Staff Augmentation Services!

Senior Database Developer Resume

Atlanta, GeorgiA

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Senior Database Developer

Responsibilities:

  • Database development and ETL support for compensation surveys report website.
  • Maintained and upgraded legacy compensation survey data flows from multiple sources into a MS SQL Server 2017 database and reporting warehouse.
  • Upgraded client data ETL systems over multiple versions including transforms that were custom made
  • Designed and built a new client portal to upload, transform, and display for editing client data which feeds directly into our main data pathway to production
  • Generated new reporting system allowing companies to compare their employees directly to market.
  • Primary production and development DBA responsible for database creation, security, backup and restores, maintenance, replication and availability of the SQL Servers version 2012,2016,2017.
  • Developed and maintained production processing reports to analyze or production build process

Confidential, Atlanta, Georgia

Database Developer

Responsibilities:

  • Primary DBA for all development servers involved with their Risk Management programs/projects.
  • Design, developed, deployed several processing enhancements of multiple clients’ daily data feeds of various formats from small clients to large financial organization
  • Worked to ensure all internal operations and development were following PCI requirements so that the organization was certified on first attempt.
  • For the PCI, developed a secure data flow of files from the client through a secure perimeter network and into our data processing pipeline. Each step was catalogued so that at any time a file’s status could be determined. The data flow used Microsoft’s MDM and Data Quality services in addition to standard ETL tools.
  • Built and provided daily management reports indicating the status and quality of the legacy data being transformed into a new data warehouse as well as exception reporting
  • Served as technical lead for junior ETL developers

Confidential, Atlanta Georgia

SQL Developer/General Developer

Responsibilities:

  • Database design and support for a centralized reporting development team utilizing several data warehouses and data marts. The ETL dataflows created were from many different locations and clients and between data marts that web reporting applications depended on
  • Design, developed, deployed Insurance Premium collected on Car Title Loans with functionality of gathering from multiple sources, aggregating the information and submitting data to partners and vendors. Data types included financial data as well as general marketing data.
  • Redesigned and deployed an ETL Process for extracting data out of MS Great Plains and posting into two separate Point of Sale systems for use in reporting.

Confidential, Atlanta, Georgia

Database Administrator and Developer

Responsibilities:

  • Extraction, Transformation, and Loading (ETL) of customer data from multiple data sources into one primary pathway into the company’s marketing data warehouse.
  • Several data extractions came from external vendors were the full cycle of data discovery to data warehouse design was utilized

Confidential, Atlanta Georgia

Database Administrator/ SQL ETL Developer

Responsibilities:

  • Database design and support for a centralized reporting development team utilizing several data warehouses and data marts. The ETL dataflows created were from many different locations and clients and between data marts that web reporting applications depended on
  • Primary Architect for data integration between a homegrown application and Great Plains. Developed system of Service Broker objects and related database objects to shorten transaction lifetime allowing for asynchronous processing of data that allowed the sending client application to not be locked for large periods of time. Developed process to extract information stored in Active Directory relating to the Line of Business (extraction included attributes and structural hierarchy information).
  • Provided Production and Development DBA duties as requested

Confidential, Atlanta Georgia

Database Engineer

Responsibilities:

  • Production level support for four (4) clients who utilize a custom software package for managing their Video Gaming Systems. Developer support for several versions of the custom software mentioned above.
  • Activities include System, Application Server, and Application performance monitoring and troubleshooting. Custom data importations into MSSQL2K5 utilizing standard and customized SSIS packages. The customized packages usually include internally developed components. Planning, implementing and supporting disaster recovery/business continuity planning (DR/BCP) operations.
  • Successfully implemented several data migrations utilizing SSIS migrating data from old platforms into new application databases.
  • Implemented several log shipping solutions to increase disaster response time and minimize downtime

Confidential, Atlanta Georgia

Senior DBA/Developer

Responsibilities:

  • Data ETL (Extraction, Transform and Loading) Engineer/Developer for project involving security access involving many different applications throughout the organization
  • Activities include Discovery, Analysis, Coding, Testing and Implementation of various data feeds from various sources into a central data mart/warehouse which will be used in analyzing and administrating security principles across the organization.
  • Data feed types include but are not limited to Linked Servers (Oracle, SQL Server 2000/2005), text files (fixed width and delimited), Active Directory integration and well as Main Frame feeds.
  • Developed and implemented standardized process, procedure and documentation for above data feeds through several custom components and SSIS as well as implementing a Reporting Server for in depth analysis and data retrieval.

Hire Now