We provide IT Staff Augmentation Services!

Technical Consultant (sql Dba) Resume

PROFESSIONAL SUMMARY:

Qualifications consist of over 10 years of Information Technology experience (Database Administration / Application & Software Development / Programming // Web Design / Administration // PC & Help Desk Support // MS System Administration //). Areas including, but not limited to: SQL (T - SQL) Programming (SSIS) Stored Procedures; Development of WinForms applications using (VB/C#); ASP.NET / XHTML/HTML, PHP / VBA; Supporting & troubleshooting of Windows 10/7/ XP Pro SP3 / 2000 / NT desktop issues, MS Exchange

PROJECT MANAGEMENT SOFT SKILLS

  • Provides satisfactory solutions to customers, which involve handling difficult situations (complaint handling, sensitive customers, etc.);
  • Build customer and partner loyalty through customer orientation, responsiveness and accountability.
  • Plan, initiate, monitor and adjust resource allocation to support multiple simultaneous projects in a Functional organizational structure.
  • Excellent communication skills, including the ability to communicate to all levels of client and internal personnel
  • Excellent problem solving skills
  • Effectively communicate with Stakeholders and provide motivation, reassurance and information regarding the ongoing projects and initiatives.
  • Efficiently coordinate and negotiate with outside Vendors, as resources, to support timeline for project deliverables.
  • Accurately communicate and coordinate with production support personnel to ensure key knowledge transfer and ongoing support of deliverable, post project completion.
  • Provide technical interpretation and understand/negotiation between resources and the business customer to ensure requirements are gathered and defined precisely and accurately and being implemented promptly.
  • Instruct, motivate and mentor junior technicians and helpdesk agents.

TECHNICAL SKILLS:

Programming Languages: T-SQL, .NET (VB), HTML5, CSS

Operating Systems and Hardware: Windows 8.1/8/7 Enterprise, Windows Server 2012 / 2008 R2

Software: SQL Server 2012/2008/2005 Administration, Visual Studio 2017/2013/2012/2010/2008, Outstanding skills/competencies in technical documentation, and training technical and non-technical staff, Proven ability to independently plan, prioritize, manage special projects, and work efficiently under deadlines.

EMPLOYMENT:

Confidential

Technical Consultant (SQL DBA)

Applications Supported/Used: Visual Studio 2017/2015/2012 ; SQL Server 2012/2008 R2 (SSMS); SSIS; MS Office 2016/2013; Win Server 2008 R2; Windows 10; Windows 7 Enterprise

Responsibilities:

  • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
  • Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
  • Configure SQL Server monitoring utilities to minimize false alarms
  • As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
  • Install and configure new SQL Servers
  • Deploy database change scripts provided by third party vendors
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Document the company’s database environment
  • Tuning T-SQL queries to improve performance

Confidential

SQL DBA

Applications Supported/Used: Visual Studio 2012; SQL Server 2012 (SSMS); SSRS; MS Office 2010; Windows Server 2008; Windows 8; Windows 7 Enterprise; Win XP Professional SP3

Responsibilities:

  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
  • Configure SQL Server monitoring utilities to minimize false alarms
  • Install and configure new SQL Servers
  • Deploy database change scripts provided by third party vendors
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Document the company’s database environment
  • Devised SQL /T-SQL queries to collect information required for various SSRS reports
  • Developed intermediate & advanced level SQL Server Reporting Services (SSRS) reports using stored procedures
  • Design and develop data movements using SQL Server Integration Services (SSIS), TSQL and Stored Procedures
  • Responsible for all project life-cycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
  • Developed WinForms and WebForms (VB), and provided support for Web Services as well as implemented data binding.
  • Responsible for all project life-cycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.

Confidential

Technical Consultant

Applications Supported/Used: Visual Studio 2012; SQL Server 2012 (SSMS); SSRS; MS Office 2010; Win Server 2008 ; Windows 7 Enterprise ; Win XP Professional SP3

Responsibilities:

  • Devised SQL /T-SQL queries to collect information required for various SSRS reports
  • Developed intermediate & advanced level SQL Server Reporting Services (SSRS) reports using stored procedures
  • Responsible for all project life-cycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
  • Developed WinForms and WebForms (VB), and provided support for Web Services as well as implemented data binding.

Confidential

Application Specialist - Staff

Applications Supported/Used: Corillian Online Banking; Mobiliti (Mobile Money); SQL Server 2008 R2 (SSMS); SSRS; MS Office 2010; Win Server 2008 ; Windows 7 Enterprise ; Win XP Professional SP3 ; Hyper - V ; Remedy

Responsibilities:

  • Remote troubleshooting of customer issues
  • Perform initial triage of high severity incidents of Corillian Online banking and Mobiliti implementations.
  • Execute SQL scripts to obtain diagnostic data, error messages, etc.
  • Analyze diagnostic data & event logs to obtain root cause of issue
  • Report findings to assembled engineering team to determine further course of action
  • Document issue resolution (escalation, resolution, etc. ) via Facets and Remedy ticketing system(s)
  • Create and maintain support documentation
  • Identify and recommend changes in support practices, maintenance and standards.

Confidential

Support Services Engineer

Applications Supported/Used: Confidential proprietary software, Visual Studio, SQL Server Mgmt Studio (SSMS)Oracle SQL Developer, FTP (IIS), SSRS, Virtual PC, Hyper-V, SQL Server 2005/2008R2, Windows Server 2008

Responsibilities:

  • Remote troubleshooting of customer issues
  • Provide timely, accurate, and friendly support to the customer base, both internal and external.
  • Maintain call information (comments) in a timely manner to ensure visibility to current call activity.
  • Reproduce the issue in-house if necessary for troubleshooting and testing.
  • Create bug fix/enhancement requests (known as SPRs) based on customer issues and feedback. These SPRs will be addressed by the Sustaining Engineering team and tested by QA.
  • Monitored and maintained FTP server
  • Developed internal Win Forms (VB) applications, and created sample code for clients
  • Assist customers with creating code samples.
  • Sample code requests can be for any supported API or Service used in InSite (XML, Web Services, etc.).
  • Database Installation & Development
  • Installed & maintained instances of SQL Server 2005/2008 R2 and Oracle 11g database environments
  • Developed intermediate & advanced level SQL Server Reporting Services (SSRS) reports using stored procedures.
  • Developed & used intermediate & advanced SQL scripts, stored procedures to perform diagnostics testing and database tuning.
  • Provide Internal support for InSite application
  • Assist internal Training and Education resources as requested to ensure training courses are able to circumvent problems that arise during training.
  • Assist internal customers with problems that arise in the course of work. These issues are entered into Support’s trouble ticket documentation system (known as Call Tracker) the same as external customer calls are logged.
  • Documentation
  • Utilize the existing Support Call Tracker system to accurately document customer issues.
  • Create postings to Support’s forum that assist the customer with “self-help” troubleshooting and provide answers to common situations/errors.
  • Assist with maintaining any relevant SOPs for job functions. This will be coordinated through the Support Manager.

Hire Now