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.
