Senior Database Engineer Resume
Raleigh, NC
SUMMARY:
- Seasoned IT professional with 7+ years of experience in development and administration of SQL server, and implementation of Microsoft business intelligence solutions.
- Extensive experience in requirement analysis, work flow analysis, design, development, testing and implementation in more than 6 complete software development life cycles SDLC with web applications and client/server technologies.
- Extensive experience in T - SQL Programming including but not limited to developing Stored Procedures, Views, Triggers, XML and Complex Queries with joins
- Expert in query optimization, performance tuning and troubleshooting using SQL Profiler, analyzing Execution Plan, Performance Monitor and DBCC statements.
- Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Mart and OLAP technologies.
- Excellent hands-on experience with Normalization, De-normalization, Relational database modeling and Dimensional database modeling (star schema and snowflake), logical and physical design for databases with tools like Erwin and Visio.
- Expertise in creating various reports such as complex drill down, drill through, Parameterized, Matrix, Chart and Sub reports using SQL Server Reporting Services SSRS based on Relational and OLAP databases.
- Highly proficient in design and development of SQL Server Integration Services SSIS packages using various control flow tasks and data flow transformations and scheduling integration packages using SQL Server Agent.
- Proficient in writing functional specifications and translating business requirements to technical requirements.
- Exceptional versatility and adaptability, extremely diligent, service oriented team player with an ability to take new roles and ownership. Excellent communication and strong analytical skills.
- Attention to detail and complex problem solving abilities from operational and technical perspective.
- Excellent interpersonal skills, communication skills, documentation skills, problem solving ability, analytical and programming skills in high speed, quality conscious and multitasked environment.
TECHNICAL SKILLS:
Cloud Infrastructure tools: AWS, ServiceNow
Scripting Languages: JavaScript, HTML 5, CSS 3, XML
Software Methodologies: SDLC, Agile, Scrum
Databases: SQL Server, Oracle 10g, MySQL
Database Tools: TOAD, SQL Developer, SSIS, SSRS, Data Stage
Programming Languages: SQL, PL/SQL, C++, VB, C#, ASP.NET
Web/Application Servers: IBM Web Sphere, Apache Tomcat
Platform: Windows, Linux, Unix
PROFESSIONAL EXPERIENCE:
Confidential, Raleigh, NC
Senior Database Engineer
Responsibilities:
- Designed, developed, maintained and enhanced database code and functionalities of the ShareFile platform and the internal CRM tool Coffee
- Worked effectively on all aspects of vertically scaled MS SQL Server instances, which support a large scale SaaS application driving over 450k queries per second with 99.95% 24/7 availability all in an agile CI/CD environment.
- Performed tuning and optimization of stored procedures
- Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
- Created entity-relationship models, normalized data to ensure the performance and integrity of databases.
- Wrote complex queries, stored procedures with parameters, and functions, views to ensure data integrity and to meet the business rules.
- Performed data transformations and ETL operations and troubleshoot packages after migration to the AWS control plane.
- Generated scripts to partition records, enumerate, find and remove duplicates
- Identified and resolved issues (troubleshoot failed jobs), deployed new code and patches, as well as database administration, user access/security administration
- Honed expertise troubleshooting SQL code using tools such as Splunk, Datadog, SQL Sentry, and tuned queries to improve performance within SLAs
- Involved in requirements gathering and design documents for developing the project.
- Created documentation including data standards, procedures and definitions
- Worked with functional business analysts, business process owners and other team members for given requirements including design, feedback and documentation for change management.
- Code reviewed and released update set to test, stage and production
- Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
- Used event handlers to capture the run time error message in SSIS package.
- Involved in scheduling, administering, deploying and debugging SSIS packages and reports from development server to production server.
Environment: SQL Server 2012, SQL Server Integration Services 2012, SQL Server Reporting Services 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Office 365, Redgate, Splunk, SQL Sentry, Datadog, Tableau, PostgreSQL, MySQL
Confidential, Miami, FL
Lead Bi Developer / Project Manager
Responsibilities:
- Performed project management and managed a team of 3 offshore developers.
- Planned out the conceptual design, implemented data mapping.
- Imported and exported data using the Import/Export Wizard for performing ETL operations.
- Created SSIS Packages to extract, cleanse and load data from clients into SQL Server development instance and then Oracle /PeopleSoft environment
- Used various SSIS transformations such as conditional spilt, derived column, look up which were used for data scrubbing, data validation checks before loading the data into Data warehouse
- Used SCD (Slowly Changing Dimension) transformation to maintain the history of data.
- Employed various control flow items such as sequence container, execute SQL task, filesystem task, FTP task, dataflow task such as Microsoft Connector for Oracle Destination by Attunity, OLE DB destination component, OLE DB, Flat file and excel source
- Gained further experience using various transformations including join, multicast, conditional split, aggregate, Task Factory custom components for Advanced Derived Column Transform and more
- Created custom script components to replace null and empty values in text and numeric columns
- Installed upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
- Created SSIS Packages to import and export data from Excel, XML and Text files.
- Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
- Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Designed a report on the monitoring of server performance using Task Manager. This report gave a detailed report to the management on the Performance of the server.
- Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
- Worked with the front-end application developers with their queries.
- Performed tuning of SQL queries and stored procedures using SQL Profiler, SQL Analyzer and Index Tuning Advisor.
- Configured SQL mail Agent for sending Automatic emails on Errors.
- Created foreign key constraints and referential integrity checks to maintain the data quality.
- Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
Environment: SQL Server 2008 R2, SQL Server Integration Services 2008 R2, SQL Server Reporting Services 2008 R2, Microsoft Visual Studio, SQL Server Management Studio, MS Office 2013, PL/SQL
Confidential, Orlando, FL
Database Administrator
Responsibilities:
- Created patient recruitment status reports with tables and charts to show performance of a study within a site against time and setup subscriptions.
- Performed data migration to various environments, automated the process using Redgate deployment manager and Octopus Deploy.
- Mapped out the conceptual design for databases and ensured the performance, integrity and security of databases.
- Involved in the installation, configuration and testing during the upgrade from SQL Server 2008 R2 to SQL Server 2014.
- Implemented security measures by controlling access permissions and privileges
- Employed backups, restores, recovery models, database shrink operations, DBCC.
- Employed SSIS Import/Export Wizard for performing the ETL operations.
- Created SSIS Packages to remove duplicate, cleanse and load data from clients into production environment, implemented SQL Server configurations and error handling.
- Solid ability to write and troubleshoot SQL code and design stored procedures, functions, tables, views, triggers, indexes, constraints, tuning T-SQL queries to improve performance.
- Experience in troubleshooting, reviewing service related reports database backups, maintenance, monitoring on a daily basis and resolving database integrity issues, performance issues, log shipping issues, connectivity issues, security issues etc. within SLAs.
- Worked with functional business analysts, business process owners and other technical team members for given requirements including design, feedback and documentation for support and change management.
- Wrote several scripts such as finding long running queries, blocking sessions, archiving data from production server to archive server and populating reporting.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
- Installed, configured, patched, and upgraded SQL Server 2008 R2 to 2014
- Generated daily, weekly and monthly trigger based reports regarding assigned projects to designated managers and clients.
- Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
- Created SQL reports, data extraction and data loading scripts for different databases and schemas.
- Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
- Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
- Involved in designing the user interfaces and writing and implementing client validation scripts.
- Implemented SQL Server Log Shipping on the Development Server.
Environment: SQL Server 2014/2008 R2, SQL Server Integration Services 2008 R2, SQL Server Reporting Services 2008 R2, Microsoft Visual Studio, SQL Server Management Studio, Windows 2008 R2 Enterprise Edition, MS Excel.
Confidential, Jacksonville, FL
SSIS/SSRS Developer
Responsibilities:
- Created world-class analytics incorporating reports with different views and dynamic dashboards with drill-down capabilities in Oracle Business Intelligence OBIEE 11g/10g
- Designed number of SSIS packages for data transfer between flat files, XML, Sales Force, Oracle, MySQL and SQL Server using different transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component etc.
- Performed a key role in the migration of reports from OBI 10g to 11g.
- Provided support by fixing incidents, and resolving issues independently and enhancing the business solutions based on the functional and strategic requirements.
- Created different types of reports such as cross tab, drill down, conditional and sub reports.
- Wrote parameterized queries for generating tabular reports and sub reports using global variables, expressions, functions, and sorting for the reports using SSRS and scheduled reports.
- Created performance reports to managers to show holding against various measures like time, area and product.
- Involved in requirements gathering and design documents for developing the project.
- Wrote complex queries, stored procedures, and functions, views to ensure data integrity, data consistency and to meet the business rules.
- Involved in deploying SSIS Packages to production from different environments, scheduling and administering SSIS Packages, creating best practices to deploy SSIS Package to Production.
- Created SSIS packages to extract data from text files, Oracle to SQL Server.
- Used SCD (Slowly Changing Dimension) transformation to maintain the history of data.
- Used event handlers to capture the run time error message in SSIS package.
- Involved in scheduling, administering, debugging and deploying SSIS packages and reports from development server to production server.
Environment: Oracle BI 11g, Oracle BI 10g, MS SQL Server 2012/2008, SQL Server Integration Services 2012/2008, SQL Server Reporting Services 2012/2008, Microsoft Visual Studio, SQL Server Management Studio, Team Foundation Server, MS Excel, DB2, Ab Initio, IBM Rational ClearCase, Data Quality Services and Master Data Services.
Confidential, Greenville, SC
Applications Engineer
Responsibilities:
- Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, application performance tuning and code reviews.
- Involved in gathering requirements, designing logical modeling and physical modeling for OLTP applications.
- Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
- Implemented complex business logic with Stored procedures, User Defined Functions, Views and wrote T-SQL batches with CTE Common Table Expressions for recursive operations.
- Created materialized views as per business requirements and wrote number of stored procedures and dynamic SQL.
- Employed various types of control flow tasks like for each loop, sequence container and script task and used different types of transformations like derived column, lookup, SCD, script component.
- Created cross-tab, drill-down, drill-through and sub-report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
- Developed reports supporting multiple, multi-select and cascading parameters using SSRS.
- Involved in scheduling SSRS reports and administrating of SQL Server Reporting Server.
- Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
- Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
- Involved in upgrading the instance of development environment of SQL Server 2000 to SQL Server 2005 with appropriate hot fixes and service packs.
- Migration of DTS to SQL Server Integration Service (SSIS).
- Created and modified data driven subscriptions, fine-tuning subscription execution.
- Created automated stored procedures for day end operations using SQL Server agent.
- Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2 and Text files and Excel files) to SQL Server.
Environment: MS SQL Server 2012/2008, SQL Server Integration Services 2012/2008, SQL Server Analysis Services 2008, SQL Server Reporting Services 2012/2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, Data Quality Services and Master Data Services.