We provide IT Staff Augmentation Services!

Sql Database Administrator Resume

3.00/5 (Submit Your Rating)

TECHNICAL SKILLS

Languages: Microsoft Transact SQL, Net, VB.Net, ASP.NET, C#ASP, DHTML, JavaScript, Microsoft C++ 6, XML, AJAX, MDX, SQL Analysis Services, LDAP, Active Directory (Visual Studio 2015)

Databases: DB2 v7, v8, Microsoft SQL Server 4.x through 2017Microsoft Access, Adaptive Server Anywhere

Applications: Microsoft Office product office suite 2016, SAP Power Designer database modeling tool, Subversion

Platforms: Microsoft Windows desktop, Microsoft SQL Server, Microsoft Windows Server platform.

PROFESSIONAL EXPERIENCE

Confidential

SQL Database Administrator

Responsibilities:

  • Provided recommendations regarding SQL server standards documentation.
  • Worked with an offsite 3rd party hosting company to maintain and upgrade over 300 data bases.
  • Optimized SQL statements to improve performance Provided assistance with SSRS and SSIS Management.
  • Reengineered and upgraded ECP’s data model to increase efficiency. Designed several tables and modified issues with several existing databases.
  • Created a template data model of ECP’s system that could be regenerated.

Confidential

SQL Database Administrator

Responsibilities:

  • Provided training, recommendations and documentation regarding SQL Server standards documentation, SSIS and DTS processes.
  • Created custom templates used to expedite daily SQL tasks.
  • Extracted Confidential ’s data model and redesigned it by reverse engineering the existing data modeling. Ran the check model to gather deficiencies in Confidential ’s model.
  • Provided a shell and developed a .Net application to display data to clients.

Confidential

SQL Database Administrator

Responsibilities:

  • Provided Marquette’s database administration staff expertise in database design and systems support.
  • Responsibilities included supporting over 100 SQL production databases on SQL Server versions up through 2014.
  • Created the initial Model Design for the ProPhoenix database system.
  • Talked with the champions of the project to gather requirements. Took the information to design the database tables.
  • Used personal tool to perform data modeling.

Confidential

SQL Database Administrator

Responsibilities:

  • Responsible for the development of several ETL SSIS packages backlog processing.
  • These SSIS packages monitoring several directories for file process by segregating the data by day, month, quarter and year.

Confidential

SQL Database Administrator

Responsibilities:

  • Used technical, leadership, and project coordination expertise to design, install, and administer database solutions.
  • Setup, configured, created, and monitored SSIS packages along with setup and configuration of SQL Server reporting Services (SSRS).
  • Created an ETL process which extracted the data from an offsite location. The data was transformed into several MSSQL databases for system reporting.
  • This process was crucial due to the nature and dollar amount of the claims received for truck damage which often totaled over $100,000 per truck.
  • Designed the data model from the ground up.

We'd love your feedback!