SQL DBA \ Developer Resume

SUMMARY:

Application\database developer experienced in the warehousing\distribution, transportation, and retail industries. Proficient in SQL Server, DB2, VB.NET, and C# skills; possess strong communication and problem solving skills. Offer experience in database skills including database development and maintenance, database tuning and troubleshooting, and backup plan implementation and testing.

TECHNICAL SKILLS:

Databases: SQL Server, DB2

Languages: Visual Basic, Visual Basic.NET, C#, ASP.NET, HTML, XML, XLST, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential

SQL DBA \ Developer

Design and maintain a database backup and recovery strategy including continual automated testing of the restoration process.
Design and develop physical and logical database structures.
Tuning queries and stored procedures for scalability and performance.
Work with application developers on overall application design and architecture.
Develop and manage ETL processes using SSIS to maintain timely information exchange between internal ERP applications and multiple vendors and clients.
Manage and administer the Reporting Services environment. Work with Analysts to ensure reports are written to standards.
Successfully developed and executed a plan to upgrade the SQL environment from SQL Server 2008R2 to SQL Server 2014.

Confidential

Database Engineer III

Acting DBA for approximately 150 application engineers supporting software installations nationwide. Duties include server setup and configuration, identifying and correcting system deficiencies, and providing database admin services to customers with no dedicated DBAs.
Identify and correct issues that are found to be database or database server related using SQL DMVs, SQL Profiler, Perfmon, PowerShell, and Extended Events.
Design and develop database objects to meet specific customer business requirements.
Work with application developers to ensure development and implementation of custom database objects adhere to SQL Server best practices.

Confidential

Senior Client/Server Developer

DBA support for a 1TB Marketing DataWarehouse. Responsible for a project to redesign the ETL process and cut the processing time by 60% and storage requirement s by 35%.
DBA support for over 1200 SQL Server instances nationwide.
Develop and test database backup and disaster recovery procedures; manage user logins and system security; responsible for database maintenance and performance tuning.
Develop and maintain SQL scripts, SQL Agent jobs, ETL Processes, and assist developers with complex queries and SQL best practices.
Design, development, and implement Visual Studio applications in VB.NET, C#.

Confidential

Systems Analyst

Implementation, maintenance, and support of custom applications in a client - server and window services based architecture including: working with business users and business analysts to define and create technical specifications for application development, application troubleshooting and investigating issues, and identifying opportunities to optimize applications and databases.
Maintenance and support of a purchased software package for fleet equipment maintenance tracking. Responsibilities include system and database maintenance, research, configuration, and testing to support changing business requirements, and application debugging and troubleshooting.

Confidential

Senior Business Systems Analyst

Maintenance of a Wolverine written Warehouse Management System. Responsibilities included continual modification of program modules to reflect changing business needs and customer requirements, conversion of modules from SQL Windows to Visual Basic.NET, and maintenance of program documentation.
Management of a purchased Crystal Enterprise based reporting application responsible for delivering real-time and scheduled reports to users in the US and Canadian distribution centers. This included development of new reports, maintenance of current reports, and management of the server.
Participation in a team environment responsible for the maintenance and support of a purchased Warehouse Management & Transportation Execution System. Responsibilities included system configuration, testing and maintenance, coordination of projects with the software vendor and 3rd party service providers, documenting and reporting software deficiencies, and testing delivered patches.
Team lead responsible for upgrade testing of the Warehouse Management & Transportation Execution System installed in the US and Canadian distribution centers. Responsibilities included identifying and scheduling testing resources, writing and executing test scripts, submission of deficiency reports, and testing delivered program fixes.