Dwayne Wright
Marietta,GA
Summary
Detailed SQL Developer with track record of success developing, testing and tuning database codes ranging in complexity. Passionate about continuous learning and emerging technology trends. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.
Overview
10
10
years of professional experience
Work History
SQL Developer
Santander Bank
10.2023 - Current
- Developed custom database objects, stored procedures and delivered application support.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed and optimized complex SQL queries resulting in a 50% increase in performance
- Helped plan data extraction and processing tasks, aiding in eventual deployments.
- Created and updated database designs and data models.
- Conducted tests to identify issues and make necessary modifications.
- Partnered with finance teams and accounting to ensure the consistency and accuracy of data and reporting.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Designed and developed analytical data structures.
SQL Developer
KPMG
09.2019 - 08.2023
- Analyzed existing SQL queries to identify opportunities for improvements.
- Performed regular database backups to prevent information loss.
- Supported projects enabling delivery efficiencies and technical resolution.
- Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, using MS SQL Server 2005. Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
- Developed custom database objects, stored procedures and delivered application support.
- Analyzed business reports for prompt communication, follow-up and ongoing support.
SQL Developer
Citigroup
02.2014 - 08.2019
- Created optimal technical solutions to user needs with in-depth system analysis.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
- Maintenance of the various database objects - tables/views/stored procedures - in SQL Server 2005 Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment Used the maintenance Plan for SQL Server databases to recreate indexes and statistics for the performance.
- Analyzed the business requirements from the given specifications.
- Worked in data mapping, enabling the extract, transform and loading of the data into target tables.
- Helped in making changes to SQL database that decreased the risk of data corruption by 50%.
Education
High School Diploma -
Essex County College
Newark, NJSkills
- Database Maintenance
- Process Mapping
- Data Modeling
- Data Formatting
- Data Validation
- Business Needs Analysis
- SQL
- Data Analysis
- Query Tools
- SQL development
Timeline
SQL Developer
Santander Bank
10.2023 - Current
SQL Developer
KPMG
09.2019 - 08.2023
SQL Developer
Citigroup
02.2014 - 08.2019
High School Diploma -
Essex County College