Production Support Sql Server

SUMMARY: * years in database development, analysis, administration, production support

TECHNOLOGIES:

SQL Server, Oracle, MySQL, Visual Studio, PuTTY, Languages- Java Script, C#, Python

Cloud technologies: AWS (RDS, Glue, Redshift, Athena, PostgreSQL)

PROFESSIONAL EXPERIENCE:

National Express

Production Support (Dallas, TX)

October 2023 to Present

Responsible for production support of data systems including making recommendations on the use of technology standards and tools, issue troubleshooting, and root cause analysis and resolution on both production and non-production environments.

SQL queries development and optimization, functions, and stored procedures to improve system performance and meet business requirements.

Collaborate across multiple IT and Business departments and external vendors to troubleshoot and resolve complex system and data issues.

Demonstrate creativity, innovation, and high performance. Performance and Interoperability Requirements. Ability to multi-task /change focus quickly.

Manage day to day issues including daily health checks of applications and processes, working closely with end users, development staff and Infrastructure teams, to prioritize and resolve and/or mitigate outages

Monitor production activities/processes to ensure timely and effective reporting, tracking, follow-up, and communication of problems to internal and external clients, technical resources, and executives

Document technical processes, procedures, and troubleshooting steps to facilitate knowledge sharing and ensure continuity of support.

Participate in on-call rotation to provide after-hours support and address critical production issues.

Collaborated with software developers to integrate database functionality into web and desktop applications.

Conducted code reviews and performance optimizations to improve application efficiency and reliability.

Walmart (Contract)

SQL Developer (Dallas, TX)

February 2023 to September 2023

Writing complex SQL Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.

Objects creation such as Tables and Views, Table Normalization, User Created Data Types, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes, and appropriate Triggers to facilitate efficient data manipulation and data consistency.

Tuning T-SQL queries (DDL, DML, and DCL) to improve the database performance and availability.

Source to Target data mapping

Development in an Agile environment

Using Jira as a project management tool.

Documenting steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production.

Ability to create new and modify existing reports and use Data Transformation Services (DTS).

Remediation of issues found during testing candidates need to be problem solvers and troubleshoot existing code based on specifications provided.

Providing Production support responsibilities for the existing SSIS Packages.

Participating in design and code reviews to maintain our high development standards.

A proven team player provides hands-on leadership while taking an active role in collaborative assessments and design.

Interpest Inc

SQL Developer (Cumming, GA)

July 2020 to Jan 2023

Involved in the ETL process (SSIS), including development and deployment using Visual Management Studio.

Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.

Objects creation such as Tables and Views, Table Normalization, User Created Data Types, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes, and appropriate Triggers to facilitate efficient data manipulation and data consistency.

Proficient in Data analysis and migration from sources like SQL server, Text Files, Excel, and CSV files to SQL server 2017/2019 using SQL Server Integration Services (SSIS).

Provided T-SQL and PL / SQL programming (Stored Procedures, Functions, joins, aggregate functions, Indexes, and Triggers) using SQL Server Management Studio.

Python programming for data cleansing and ETL automation.

Responsible for analyzing and validating data, and/or updating source-to-target maps. Help perform source analysis and support departmental process improvement initiatives.

Collaborate with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies.

Maintained E-R (Entity-Relationship) diagrams and data dictionary normalization.

Provided application support (troubleshooting and resolving production issues).

Provided client setup and production support.

Installed and upgraded, provided service packs and security updates, and configured SQL Server 2017.

Provide timely scheduled management reporting.

Develop, implement, and optimize stored procedures and functions using T-SQL.

SKILLS AND COMPETENCES:

Excellent understanding of T-SQL programming

Strong technical and analytical skills

Experience with Agile Scrum, Kanban

Excellent understanding of Microsoft SQL Server

Familiarity with the practical application of NoSQL\NewSQL databases

Strong collaboration and communication skills and the ability to work on a team.

Sense of ownership and pride in your performance and its impact on company’s success

Highly proficient in writing advanced SQL queries, stored procedures, and ETL processes.

Good Understanding of Linux environment

Proficient knowledge of Microsoft Windows Server and Linux operating systems

Critical thinker and problem-solving skills

Good time-management skills

Great interpersonal and communication skills

Learn fast and enjoy learning new technologies.

EDUCATION:

May 2021: Associate Degree in Applied Science Database Specialist, Georgia Piedmont Technical College: Georgia, Atlanta

May 2021: Diploma of Database Specialist, Georgia Piedmont Technical College: Georgia, Atlanta

May 2021: Technical Certificate of Credit in Oracle Database Administrator, Georgia Piedmont Technical College: Georgia, Atlanta

May 2021: Technical Certificate of Credit in Information Technology Fundamentals, Georgia Piedmont Technical College: Georgia, Atlanta

Nov 2014: Bachelor of Science, Computer Science, Nagui-Abrogoua University: Ivory Coast, West Africa

LANGUAGE:

English -Fluent

French -Native

Contact this candidate