We provide IT Staff Augmentation Services!

Sql Specialist Resume Profile

5.00/5 (Submit Your Rating)

Objective

To obtain a challenging position in a growth-oriented organization, which offers diverse job responsibility.

Skills

  • Results-driven expert skilled in phases of computer technologies including network server installations and tuning configurations, PC network backup, and system upgrades, system patches
  • Provides ongoing analysis, maintenance, and technical and functional support for application systems throughout the organization
  • Proactive self-starter known to initiate processes and system improvements to increase system stability and staff productivity
  • Secure networking, hardware software administration and integration.
  • Applications development and design deployment
  • Over 5 years of progressive computer network operations in large global data centers with mixed computing environments including Unix , Windows and interconnected mainframes
  • Solid understanding of relational databases
  • Aptitude for analyzing, testing, debugging code, identifying problems, and creating solutions
  • Flexible, self-motivated creative problem solver.
  • Excellent problem-solving and strong analytical skills.
  • Strong oral and written communication skills, management and leadership skills.
  • Able to deliver informative, well-organized presentations
  • Detail oriented and accurate with strong work ethics.
  • Capable of learning new technologies, company cultures processes, and successfully applying them to projects and operations.
  • Aptitude for analyzing, testing, debugging code, identifying problems, and creating solutions
  • Strong organizational and interpersonal skills.

Work Experience

Confidential

Title: SQL/Telecom Specialist

  • Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
  • Worked closely with marketing and call center teams to gather change requests, convert into technical documents and implemented those based on schedule.
  • Developed scripts on the spot to react to unforeseen problems and also to pro-actively automate future task. Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Expert in developing Data Definition Language DDL and Data Manipulation Language DML
  • Wrote SQL Queries, Joins involving multiple tables, TSQL, Stored Procedures, Views, Functions, database Triggers.
  • Create/Edit/Maintain ETL processes utilizing Microsoft SQL Server Integration Services SSIS from a diversity of data sources including other servers, flat files, MS Access and Excel.
  • Utilized Powerpivot to cleanse tables and facilitate excellent analysis for large data sets of millions of rows, combining data from multiple sources to create visually appealing analytical models of data
  • Used SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Worked on administration tasks such as data loading, batch jobs, data uploading, backup recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs. Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server
  • Reporting Services SSRS .
  • Administered Avaya Interaction Center workflow for Email/ Chat and Call routing.
  • Tested applications and communicated issues and resolutions
  • Designed and developed specific databases for collection, tracking and reporting of data.
  • Created and managing Avaya Infrastructure diagram using MS Visio for detailed cabling and rack elevation along with each call flow. Managing procedures and policies for telephony administration and preventive maintenance.
  • Performed and conducted complex custom analytics as needed by executive management.
  • Managed call flow programming using vectors, VDNs and BSR treatment for calls to send over. Also created call flows for remote support to activate and deactivate variables

Confidential

Title: Systems Analyst

  • Install and configure components to support advertising billboards
  • Operate and monitor control room for ABC news located centrally in Times Square
  • Provided user assistance and training with operation of multimedia systems.
  • Manage audio and video data feeds for the Good Morning America Show in Times Square
  • Provided digital video and audio editing and duplication if needed.
  • Provide remote assistance through VPN tunnel when needed to restore services located in the control room.
  • Schedule ads to appear on billboards at certain times throughout the day at various places throughout Times Square
  • Manage audio, video, servers, PC's locally and remotely from the control room
  • Provided technical support for meetings, conferences, classes and corporate-wide broadcasts.

Confidential

Title: Technical Support Consultant

  • Install and configure peripheral components
  • Answer questions about operation, installation, and configuration of existing hardware and software
  • Update and maintain website and database of users
  • Expert level HTML, CSS, and Javascript including AJAX/JSON and libraries like jQuery , including semantic markup, as well as a great deal of experience with SEO search engine optimization and web-based user interface design. Extremely comfortable working within MVC template frameworks like Rails, and administering Apache web servers.
  • Considerable knowledge of design, administration, and performance tuning of MySQL. Also experienced at designing databases and fine tuning complex queries.
  • Troubleshoot compatibility conflicts, application errors and recommend solutions to correct problems.

Confidential

Title: Help Desk Associate I and II

  • Apply basic diagnostic techniques to identify problems, causes and apply solutions
  • Escalated issues as needed and maintained communication between customer and technical teams while extensively utilizing REMEDY to record and track issues
  • Support as necessary on a 24-7 basis to limit system down time during internal or external outages and peak enrollment periods
  • Regularly provided efficient technical support over the phone, maintaining presentable phone demeanor, courtesy, and creativity.
  • Troubleshoot problems involving hardware, software and system compatibility conflicts and malfunctions, application operations, connectivity issues, telecommunications problems in a LAN/WAN environment, network, security, and printing issues.
  • Assisted 500 users with policies and procedures for setting up conference calls, new accounts, web/network presentations and voicemail.

We'd love your feedback!