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:
- Responsible for modernizing teh SQL environment in support of financial end of year reports.
Confidential
SQL Database Administrator
Responsibilities:
- Provided recommendations regarding SQL server standards documentation.
- Worked wif an offsite 3rd party hosting company to maintain and upgrade over 300 data bases.
- Optimized SQL statements to improve performance Provided assistance wif SSRS and SSIS Management.
- Reengineered and upgraded Confidential ’s data model to increase efficiency. Designed several tables and modified issues wif several existing databases.
- Created a template data model of Confidential ’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 teh existing data modeling. Ran teh 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 teh initial Model Design for teh ProPhoenix database system.
- Talked wif teh champions of teh project to gather requirements. Took teh information to design teh database tables.
- Used personal tool to perform data modeling.
Confidential
SQL Database Administrator
Responsibilities:
- Responsible for teh development of several ETL SSIS packages backlog processing.
- These SSIS packages monitoring several directories for file process by segregating teh 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 wif setup and configuration of SQL Server reporting Services (SSRS).
- Created an ETL process which extracted teh data from an offsite location. Teh data was transformed into several MSSQL databases for system reporting. dis process was crucial due to teh nature and dollar amount of teh claims received for truck damage which often totaled over $100,000 per truck.
- Designed teh data model from teh ground up.
