Resume

Sign in

Microsoft SQL Server (DBA)

Location:
Chicago, Illinois, United States
Salary:
80000.00
Posted:
January 26, 2018

Contact this candidate

NOORUDDIN HIRJEE

**** ***** ******** *** 773-***-****

Chicago, Illinois, 60660 ac362y@r.postjobfree.com

Summary

Highly motivated and result-oriented data analyst and business intelligence professional, I have over 5 years ‘experience in business requirement gathering, system needs analysis, data gathering, data integration and transformation, data analysis, and presentation to various management groups. My specific skill sets include:

•5+ Years requirement gathering, business process analysis, design, documentation, and project design and Management.

•5+ years SSIS/DTS (data migration, transformation, integration and analysis) with SQL Server, and Oracle

•5+ years, reports development with SQL Server (SSRS)

•5+ years data integration, transformation, and analytical services development using SQL Server (DTS, SSIS, )

•5+ years T-SQL programming (T-SQL, DDL/DML) using Microsoft SQL Server, Oracle.

•Excellent skills in training and presentation to management groups

•ACCESS CONTROL POINT ( SQL SERVER SECURITY)

TECHNICAL SKILLS:

•Operating Systems

94/98/ME/NT/2000/XP/2004/2008,/2012/Vista/Win7, and windows

RDBMS

SQLServer,2014/2012/2008R2,2008,SSIS,SSRS,DTS, PL/SQL, Linked, Function, Toad, T-SQL

Tools

SSIS, Red Gate, Erwin, RMAN, OEM, Data pump, Export/Import utility, SQL Developer, TOAD, SQL Loader,

Languages

T-SQL, SQL, PL/SQL

•Tuning Tools

Sql Server Profiler, Traces, Database Engine Tuning Advisor, Execution Plans and Extended Events

High Availability

Mirroring, Log Shipping, Replication, and Always On Availability Groups

Hardware Platform

Sun Solaris M4000/M4000 servers, Sun Fire E24K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6400 / 440, HP XP246 / XP412, IBM X series Server, and various PC desktop and servers.

EDUCATIONAL QUALIFICATION

BACHELOR OF COMMERCE IN ACCOUNTING

YEAR: 1982

Certifications: Microsoft Certified Technology Specialist - SQL Server DBA, Oracle Certified Associate - Oracle 11g Administrator, CompTIA A+ & Network+

REFERENCES

• References available upon request

WORK AUTHORIZATION: US CITIZEN

CAREER OBJECTIVE

Looking for a premier field engineer job with Microsoft to help clients establish a reliable SQL Server environment and help them to adapt to new changes in SQL Server technology.

TECHNICAL SKILLS

• Operating systems: Windows server 2003, Windows server 2008, Windows server 2012,

• DBMS: SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, 2014

• Language: T-SQL, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

State Farm Insurance, Bloomington, IL

SQL Server DBA

April 2012 – till date

Database Administrator

• Designing and architecting future production environment using SQL Server availability group and failover technology

• Setting up failover cluster / Always-On Availability Group for SQL Server

• Setting up/ maintaining / troubleshoot SQL Server Replication

• Performance tuning for production SQL Server environments

• Maintaining SQL Server lower life cycle environments

• Query tuning / optimization stored procedures

• Migrating / Consolidating SQL Server databases

• Updating database systems by reviewing, planning, testing and installing database security patches and service packs

• Migrating application code and objects from development/test environments to production

• Prepared Documentation for the Disaster Recovery plan

• Designed Data Integrator jobs with Error Handling and email notifications.

• Providing 24/7 production/corporate DBA support for SQL Server 2005, 2008, and 2012

• Monitoring production SQL server cluster, DR, and replicated SQL Servers

• Developing and implementing disaster recovery plan

• Setting up and maintaining database replication and point-in-time restored

• Developing backup and restore system

• Setting up and maintaining SQL Server 2012 Availability Group

• Maintaining testing environments

• Developing blocking capture alert system

• Developing centralized job system

• Developing multi-threaded stored procedure

• Managing and tuning indexes

• Developing, and tuning queries, stored procedures, triggers and functions

• Reviewing and testing SQL scripts before releasing to test/production environments

• Responding to and resolving database performance issues.

• Providing 24/7 production DBA support

• Creating Clustered Indexes and Non-Clustered Indexes to increase the performance of database queries

• Developing stored procedures and functions to improve daily performance

• Reviewing and testing SQL scripts before releasing to test/production environments

• Moving databases from Production to Test environment on request

• Performing defragmentation and rebuilding of indexes periodically on the production tables



Contact this candidate