SQL Server Administrator / Developer Resume

TECHNICAL SKILLS:

Technical Microsoft: SQL Server 2012/2008R2/2005/2000, Microsoft Visual Studio 2012/2010/2008 , SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Database Design and Security, Database Tuning and Performance, Tableau, SAS, SPSS, Teradata, RedGate, Cisco TES (Tidal Enterprise Scheduler), MS Office, Visio, Project, MS Access, Windows OS, Linux.

Languages: T - SQL, PL-SQL, Teradata SQL, VB.NET, ASP.NET, VBA, XML, HTML

Certifications: Microsoft Certified Professional (MCP) 70-463, Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

PROFESSIONAL EXPERIENCE:

SQL Server Administrator / Developer

Confidential, NY, NY

SQL Database Administration on Production and Development Databases with Server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. Produce documentations including Database Diagrams, process specifications and database disaster recovery plans.
Create data load processes using SSIS, SSDT, DTS, and Bulk Insert for Data Warehousing Solutions. Expert in T-SQL writing stored procedures, triggers, functions and views.
Involve in data analysis to create various Medicare adhoc reports on membership, claims, enrollment, providers and agent data using SSRS and T-SQL. Automate daily, weekly and monthly reports with SSIS.
Execute database migration from SQL Server 2008 to 2012, upgrade SSIS packages and reports. Troubleshoot performance process, fine-tune databases and index analyses and optimize complex queries.

SQL SERVER ADMINISTRATOR

Confidential, NY, NY

Designed, implemented and maintained SQL (2012, 2008r2, 2005, 2000) databases of various customer data. Administrated SQL Server High Availability and Disaster Recovery strategies. Managed user permissions and access levels on production databases.
Worked with SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
Responsible for monitoring and making recommendations for performance improvement in hosted databases. Provided 24x7 Production Database on Call Support.

SQL DATA DEVELOPER / PROGRAMMER ANALYST

Confidential, Piscataway, NJ

Managed a large SQL Server Database containing up to 200 million records. This included data loading, warehousing, creating operational database and designing data process. Produced SQL queries and SAS scripts. Developed custom tools for data processing and optimization. Work on process automation and maintain documentation.
Oversaw implementation of marketing campaigns per client-specific requirements. Implemented client marketing models using SAS. Established deliverables with feed provider vendors and negotiated Service Level Agreements. Improved data processing time in order to fulfill customer requests more effectively.
Created and hosted presentations for internal and external clients across multiple regions using various web conferencing techniques. Wrote and revised operating and business training and technical documentation, end user manuals, business requirements and flow charts.
Designed and developed in-house CRM system with a customer-facing component using Visual Basic and SQL Server. Performed business and data analysis, requirement gathering for developers and users.

CAMPAIGN MANAGER / PROGRAMMER ANALYST

Confidential, Piscataway, NJ

Developed and supported production processes for numerous clients. Created and revised training and technical documents and end user manuals. Created and delivered to customers various campaign performance reports using various metrics. Oversaw data processing and security management.
Supported applications designed for maintenance of the databases using Visual Basic and SQL Server. Responsible for updating and maintaining of various MS SQL Server, MS Access, Oracle and FoxPro databases of consumer data. Administered Active Directory and Microsoft Exchange Server. Installed and provided technical support of software packages and operating systems. education

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship