Sql Database Administrator Resume
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 AdministratorResponsibilities:
- 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.
