We provide IT Staff Augmentation Services!

Senior Database Engineer Resume

0/5 (Submit Your Rating)

Scottsdale, AZ

SUMMARY

  • Successful IT professional with deep IT/Database experience in both large fortune 500 companies and small to medium startups.
  • In addition to a strong IT background, my finance background is a key asset in blending the lines between business and IT.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Senior Database Engineer

Responsibilities:

  • Served as lead SQL Server database administrator.
  • Tuned up a large array of SQL Servers and other services in azure to reduce monthly bill by 20k.
  • Introduced Databricks, Python, PySpark and setup dev/test/prod workspaces to solve the data needs of the company in newly realized projects.
  • Introduced Synapse Analytics to the company to help with ad - hoc type of analysis against data lake storage.
  • Helped migrate multiple SQL Server environments to Azure.
  • Introduced new developer productivity tools like ReGate and SQL Examiner to help the SQL developers with productivity gains.

Confidential, Hartford, CT

Lead Consultant, Data and Analytics

Responsibilities:

  • Provided exceptional consulting services on the Azure Data Platform for a Microsoft Gold Partner.
  • Architected complete data solutions using the many services in Azure.
  • Use of the following technologies to offer clients amazing solutions: SQL Server, SQL Synapse Dedicated Pools, SQL Serverless Pools, Synapse Analytics Studio, Databricks, Data Factory, Data Lake, Key Vault, Azure Functions, Spark, Python and Power BI.
  • Mentored clients on Analytics best practices such as: Kimball dimensional modeling and Business Event Analysis & Modeling (BEAM).
  • Drafted new architecture drawings.
  • Priced out newly proposed Azure environments out in detail for clients.

Confidential, Tempe, AZ

Senior Data Engineer

Responsibilities:

  • Delivered de-normalized fact tables to analysts using SQL Server and SSIS.
  • Used Databricks to analyze high volume of event data in parquet and delta files on AWS, using Python and Spark SQL
  • Helped start a migration project to move over large SQL Server tables to Snowflake.
  • Met with analysts to gather requirements and deliver on ticket requests.
  • Reviewed analyst SLQ queries and optimized them before deployment.

Confidential, Chandler, AZ

Lead Data Engineer

Responsibilities:

  • Overall development with a wide array of tools: SQL Server, Synapse, Databricks, Azure functions, Python, PHP, MSSQL, MySQL and PowerBI.
  • Administered the entire Azure platform for our analytics team.
  • This included complete administration of Synapse, SQL Server, Databricks, Data Factory, Data Lake, Azure Functions, Key Vault and a few more services.
  • Lead Python and SQL developer.
  • Administered and helped maintain and build out our SQL Server data warehouse.
  • This included 15-minute refreshes of our dim, fact and flat tables using Data Factory.
  • Lowered the SQL CPU utilization from an average of 80-90% to under 40% consistency for the same cost, as part of tuning efforts.

Confidential, San Diego, CA

Lead SQL Server Developer / DBA / Web App Developer

Responsibilities:

  • Helped build this amazing startup with an original 12 team members, 5 being engineers, which ended up with over 400 corporate clients.
  • Led and mentored 3 sql developers to adopt best practice coding standards.
  • Led new SQL Server Reporting Services and related BI initiatives.
  • Main resource for SQL Server development, tuning and performance issues.
  • Coordinated with hundreds of clients to address Product / SQL Server performance issues.
  • Full stack web application developer for client facing apps.
  • Built a product line of applications from the ground up to solve key issues in the industry.

Confidential, Upland, CA

Senior SQL Server Developer

Responsibilities:

  • Responsible for web-based reporting in our Software as a Service product.
  • Provided performance tuning, index optimization in a multi-terabyte database environment.
  • Developed SSRS reports for internal and client use.
  • Performed minor updates to C# code.

Confidential, Mesa, AZ

Lead Database Architect / SQL Server DBA

Responsibilities:

  • Lead IT initiatives: Business Intelligence, Internal and External application development, Customer Integration and other mission critical apps.
  • Played an instrumental role in helping the company make the INC 500|5000 list 4 years in a row, and to this day 13 consecutive INC 5000 awards have been awarded to the company.
  • Played a key tech role in growing from 7MM to 50MM of annual revenue in 4 years.
  • With additional acquisitions the company is now approaching 500MM in annual revenue.
  • Mentored 3 junior engineers who became Sr Level at the company.

Confidential, Scottsdale, AZ

SQL Server Developer / DBA

Responsibilities:

  • Collaborated with ASP.Net and PHP developers to develop web applications.
  • Worked across a multitude of knowledge areas including CRM, Fraud, Legal, Social Media, Service Desk, Automation, Server Management, Call Center, etc.
  • Handled issues alongside other DBAs to fix issues in production.

Confidential, Phoenix, AZ

Database / Business Intelligence Developer

Responsibilities:

  • Developed sophisticated reporting using SQL Server, DB2, Oracle, SSIS and SSRS.
  • Handled projects from start to finish, from gathering requirements to the final solution.

Confidential, Tempe, AZ

Lead SQL Server Developer / Business Intelligence Developer

Responsibilities:

  • Developed a library of reports spanning across sales, administration, inventory and other key areas.
  • Developed custom web applications for internal tools needs.

Confidential, Pasadena, CA

Senior SQL Server Developer / DBA / Web Developer

Responsibilities:

  • Financial/Business Analyst in first year, then promoted to developer roles.
  • Database administrator for multiple SQL Servers, including installation, configuration, testing development and tuning.
  • Head ETL and database developer for a new mission critical system. .

We'd love your feedback!