We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

TECHNICAL SKILLS

DATABASE: MS SQL Server 2019 - 2017-2016-2014-2012-2008 R 2-2008-2005-2000 , MS-AccessMS Excel, SSIS (Integration Services, Data Transformation Services), SSRS (Reporting Services)SSMS (Management Studio), SSAS (Analysis Services), Power BI Reporting

OPERATING SYSTEMS: Windows Server 2016-2012-2008 R2 - 2003 - 2000 - NT: Windows 10 - 8 - 7 - Vista – XP – 98 – 95 – 3.1

SOFTWARE: SQL Server Data Tools (SSDT), MS Visual Studio 2017-2015-2013-2012-2010-2008-2005 –2003-6.0BIDS 2010, MS Office Suite 2019-97 (Word, Excel, Outlook, PowerPoint, Access), Crystal ReportsSQL Reporting Services, MS Visio, Visual Source Safe, MS Project, IIS, Active Directory, Power BIMicrosoft CRM Dynamics, MS Team Foundation

LANGUAGES: Transact-SQL, VB.NET, C#.NET, ASP.NET, Visual Basic, ASP, JavaScript, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

  • Designed/Built/Configured Data Warehouse, performance/status reporting and email alerts
  • Developed ETL for Data Warehouse using Linked Servers, Dynamic SQL, XML, table stored queries
  • Built/Maintained SSIS packages, managed scheduling, email alerts and security handling
  • Rewrite existing SSRS reporting environment to Power BI reports
  • Optimization and maintenance of all SQL Server database through automated jobs and indexing
  • Database development for various ETL, Database Administration, and common databases
  • Database backup jobs utilizing incremental for point in time restores
  • Performance monitoring for Database & Application Servers, documenting, and centralization
  • Troubleshoot application and database issues applying fixes, adjustments, alerts and security
  • Implementing and managing best practices for application, maintenance and system security

Confidential

Developer

Responsibilities:

  • Troubleshoot application and database issues
  • Recommend performance enhancements for SQL Server database
  • Applied indexing to various SQL tables for optimization of queries
  • Automated reporting using SSRS and SSIS
  • Created testing and development environment setup and configured Servers
  • Tracking projects in JIRA using Agile/Scrum Methodologies

Confidential

Database Administrator / Database Developer / IT Manager

Responsibilities:

  • Developed/maintained databases transactional/data warehouse, tables, stored procedures,views, functions, triggers, constraints, indexes, logins, synonyms, roles, schemas, linked serversper requirements of new and existing projects
  • Developed import process handling all incoming files from multiple sources.The ETL process retrieved files of different formats, formatted the data, performed database lookupsprocessed against business logic and loaded the information to SQL databases, includingMicrosoft CRM Dynamics using SQL Server Data Tools (SSDT) 2014, SSIS & MS Visual Studio 2015 & 2013
  • Created SSIS packages, SQL jobs, schedules, reports using SSRS and Power BI
  • Microsoft CRM Dynamics database and application knowledge
  • Database backups/restore, transactional logging, disaster recovery plans, log shipping,capacity planning, email alerts, and system logging events
  • Configured application and database servers, SQL email, data collection SQL MDW, SQL Agent,reporting server, logins, roles, users and security
  • Managed indexing of databases utilizing Database Tuning Advisor, execution plans, & dynamic view
  • Migrated databases from SQL Server 2000 to 2008 to 2008R2 to 2012 and then to 2014 graduallyas the new releases became available and demonstrated stable over the course of time
  • Monitored the performance of the database environments utilizing tools such as:SQL Management Data Warehouse, Extended Events, Performance Monitor, ProfilerData Management Views, Execution plans, DBCC commands, and System monitor
  • Developed front end applications for managing backend data using visual studio .net
  • Managed and guided the IT department, consisting of SQL developers and network administrators,communicating with the owner and company management on projects, systems functionality andworker project performance

Confidential

Web Developer

Responsibilities:

  • Implemented, installed, design, develop setup and managed relational SQL Server 2000
  • MS Access to SQL Server migration
  • T - SQL, extensive queries, tables, indexes, views, stored procedures and programming
  • Setup and managed backups and restore of SQL databases
  • Setup and managed security, permissions and authentication of users
  • Disaster recovery, log transaction restoration, performance optimization
  • Created and managed DTS packages / jobs management SQL Server agent
  • Development of web reports using Crystal Reports and SQL Reporting Services
  • Programming /Development: VB.NET, C#.NET, Visual Basic
  • Work with development team implementation of System Development Life Cycle
  • Designed, built and implemented company Intranet
  • Built applications in ASP.NET and SQL Server for inventory management
  • IT Manager- team of 2 Network Server Client Administrations/ hands-on experience
  • Implemented and setup Proxy server, Web Server with IIS and SQL Server
  • Managed File server, Print server, and DNS server in Windows Server 2003 environment
  • Created and managed users and groups with Active Directory
  • Managed and setup up printers, networked and local

Confidential

Offer Operations Analyst

Responsibilities:

  • Identify/develop logistics; meeting requirements of clients and consumers in rebate fulfillment industry
  • Administration/maintenance of MS SQL Server 2000 databases and T-SQL
  • VBScript, T-SQL, XML, ADO, SQL Server 2000, Query Analyzer, Enterprise Manager, MS Access and Excel, Procedures and Functions
  • Analyzed, tested and reconstructed coding logic determining if accurate and pertinent for database maintenance while meeting and maintaining company standards and specification
  • Configured a multitude of data entry forms for capture of customer information in databases
  • Developed various applications/programs meeting accuracy & cycle operations in a timely manner

Confidential

Database Coordinator

Responsibilities:

  • Developed automated systems for information storage, retrieval, calculation, & data comparison
  • Maintained database information of employees, system performance, and product detail
  • Created/developed graphs using Visual Basic/Excel and Setup auto generated Crystal Reports
  • Daily reporting on pharmaceutical dispensing, system performance and employee progress through SQL generated queries, Crystal/Access reports and automated Excel VBA Macros

Confidential

Information Specialist

Responsibilities:

  • Enhanced client company website, mirrored off of government regulatory compliance website, providing the customer with a more user-friendly environment through clickable links to related regulations, statutes, and registers
  • Designed webpage’s for clientele, displaying related compliance information in an environment resembling their own home site by using HTML, CSS, Web Scripting, and Paint Shop Pro
  • Desktop Support, hardware\software installation & upgrades for entire workplace
  • Developed reports regarding company system information to intranet using XML

Hire Now