Senior Sql Developer Resume
5.00/5 (Submit Your Rating)
SUMMARY:
I am Senior SQL Developer with deep experiences as a Business Intelligence Developer and D.B.A. and with master’s degree in Data Analytics and over 14 years of experience working with the Microsoft SQL Server stack as an SQL developer, database administrator, business intelligence developer as well as an analytics and machine learning resource.
TECHNICAL SKILLS:
Database Architecture, TSQL Queries, Stored Procedures, Views and Functions, SSAS, MDX, SSIS, SSRS, R/R - STUDIO, SAS Enterprise Manager, Tableau, Data mining, Predictive modeling, Data visualization, Machine learning, Big data analytics.
PROFESSIONAL EXPERIENCE:
Confidential
Senior SQL Developer
- Created multi-terabyte data mart to service over 80 external client’s data analytics capabilities.
- 9+ years in MSSQL Server Stack constructing complex TSQL queries, stored procedures, views and functions optimized for performance.
- 9+ years in MSSQL Server Stack constructing complex SSAS Business Intelligence data mart and database configurations optimized for performance.
- Modeled relational databases (OLTP) databases ensuring normalization, reducing redundancy, providing data integrity and server performance.
- Modeled multi-dimensional (OLAP) databases ensuring proper configuration of fact and dimension tables into star and/or snowflake schemas for presenting aggregates.
- Tailored solutions for Management Dashboards, Financial Reporting and Operational Business Intelligence.
- Created and maintained SQL Server database and log backups.
- Sole resource architecting ETL to DataMart and BI configuration and production support for client websites across the enterprise.
- Created a machine learning project to identify causes of hospital readmits for Medicare and Medicaid patients.
Confidential
SQL Database Administrator
- Supported 400 production jobs across 330 databases with an uptime of 99.8% across an enterprise responsible for billing $650 in revenue annually.
- 5+ years providing 24/7 support of mission critical MSSQL databases.
- Developed and implemented Disaster Recovery plan, processes and procedures.
- Modeled relational databases (OLTP) databases ensuring normalization, reducing redundancy, providing data integrity and server performance.
- Constructed complex TSQL queries, stored procedures, views and functions optimized for performance.
- Responsible for reviewing, approving, implementing all SQL code that ran on enterprise servers.
- Created, maintained SQL Server database and log backups, Replication and Snap Shots.
- Created and maintained users, logins, assigned roles and object level permissions for security.
- Represented database team’s interests in change control board.