We provide IT Staff Augmentation Services!

Microsoft Sql Server Dba Resume

4.00/5 (Submit Your Rating)

Memphis, TN

SUMMARY:

Confidential is an Associate in the Application Management service line of the Federal Practice . He has over 2 years of experience in the financial services industry mainly focusing on banking. In financial services he has mainly developed functional and technical knowledge of banking applications. He also has over 7 years of experience in the supply chain and distribution industry. In this industry he modified prepackaged applications from various vendors to meet the customization needs of his companies worked for. The Software Development Life Cycle was used to do this. Confidential has worked both in commercial and federal over the course of his career. He has extensive knowledge in technologies such as UNIX Vi Editor, KornShell Scripting, SQL, PL/SQL, Business Objects, and TOAD.

TECHNOLOGIES

WMS Applications: Confidential WMS, Baan ERP

Financial Applications: LaserPro, Calyx Point, Fiserv Director and Nautilus

Programming: KornShell, SQL & Oracle PL/SQL, IBM Relational Robot, AutoIT, SQL Anywhere, MS SQL Server 2005, MS Access 2007, Toad Data Point

Platforms: Windows, UNIX, Linux (RedHat), Vi Editor

Networks: Cisco, Alcatel, Nortel, Extreme Gear, Avaya

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

Microsoft SQL Server DBA

Responsibilities:

  • Created usernames and access for team members to use the development and production databases.
  • Created databases, tables, and views store data for the project.
  • Reviewed SQL queries to optimize them as needed. Also created jobs, alerts, and scheduled SSIS Packages in SQL Server Agent.
  • Help with creating Data Flows for project Packages ran by SQL Server Agent in Microsoft Visual Studio.
  • Writing T - SQL for team members to check data format for frontend application.

Confidential

Responsibilities:

  • Conducted assessments of the technology landscape of failed financial institutions, performed the analysis, collection and migration of institution data for storage and reporting, wrote and executed SQL queries to extract failed financial institution data during the post-closing process of bank receivership.
  • This data included loan origination, deposit origination and financial analysis information, developed scripts to automate the extraction of images and financial data from core banking applications, developed intellectual collateral for loan origination applications which provides a standardized process for capturing, migrating and documenting electronically stored financial data, and performed QA on project deliverables to ensure adherence to both client and Deloitte standards and quality.

Confidential, Southaven, MS

WMS Systems Analyst

Responsibilities:

  • Designs new IT solutions to improve business efficiency and productivity for various departments in the warehouse.
  • Works closely with management to examine existing business models and flows of data, discuss the findings with management, and design an appropriate improved IT solution.
  • Outlines processes and designs new IT systems by specifying the system operations and the way data will be viewed by the user. Presents the design to management and after approval, works closely with the management, IT, and associate team to implement the solution.
  • Works as primary liaison between management and IT.
  • Uses TOAD query and Access 2007 to manipulate data for the optimization of every department of the facility

Confidential, Memphis, TN

WMS Systems Analyst

Responsibilities:

  • Utilized KornShell Programming, Vi Editor, Unix Scripting, and UNIX as tools to help aid in the behind the scenes to make changes and improvements to the WMS Confidential suite needs.
  • Used SQL and PL/SQL to query against the Oracle Database to create Confidential functions for the warehouse associates and management to use for daily tasks.
  • Created reports and user friendly functions to help aid the warehouse users to do their various jobs faster and more efficiently.
  • Examples of UNIX script files created for Confidential:
  • Nonstandard Pick Management is a function created to aide Picking management in tracking nonstandard time for Pickers of the warehouse.
  • This function allows management the ability to question suspicious times logged and the ability to change them.
  • Nonstandard Pick function was created to automate the nonstandard time process for Pickers in an attempt to cut paper cost and misleading time tracking. Works hand in hand with NONPICMG.
  • This function was created due to the fact Confidential does not have the ability to record carrier shipping labels from a tethered scanner. This function trims off the leading and trailing digits to get the actual tracking numbers to update the record in Confidential Oracle tables. They hand to do this manually before this function.
  • This function was created to help the company save money due to the financial strain of the economy.
  • Confidential was buying labels that we use for internal tracking for packages shipping to various customers from an outside source.

Jr. WMS Systems Analyst

Confidential

Responsibilities:

  • Administered WMS application software to conform functions to the business process needs of all Confidential business units under the direction of the Confidential Application Manager.
  • Worked closely with the Confidential Application Manager, the Warehouse Manager, MIS, sales, and customer service staff, and frequently customer and client personnel in order to help define and implement workflow processes in the company’s WMS application that will accurately, efficiently, and timely support the business needs of the company.
  • Served as primary backup to the Confidential Applications Manager and serve as initial contact for questions and issues related to the WMS application.
  • Maintained users and user access to the WMS application.
  • Configured Confidential to use new functions for the continuation of Pick, Pack, and Shipping in our new facility.
  • Used SQL Plus and UNIX as tools to help aid in the behind the scenes to make changes and improvements to the WMS Confidential suite needs.
  • Handled support calls from the warehouse.
  • Answer phone calls from warehouse management and associates to resolve issues or grant access to the Confidential Application functions.
  • Primary support of the conveyor system software called Sort Director by Dematic Corporation. See that the conveyor works properly mechanically, software, and communication between them.
  • Answer phones calls after normal working hours. Trouble-shoot critical order, inventory, and user error problems that may keep orders from shipping out the warehouse.

Telephony Technician

Confidential

Responsibilities:

  • Loaded operating systems, Televantage Software, Service Packs, other various software, and installing cards into servers.
  • Also built Intel servers from the ground up including system boards, hard drives, processors, memory, and CD-ROM drives.
  • Worked on Avaya MSS-H and MSS-S installing Red Hat Enterprise Linux ES “Avaya Modular Messaging Message Storage Server Software” to configure the logins and passwords for the system.
  • Performed backup testing on DVD-ram cartridge.

We'd love your feedback!