Senior Database Engineer Resume
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. .
