JAMIL NIKKON

**** *********** **. ******, ** ****3

Phone: 972-***-****(C)

Email: ac7w1k@r.postjobfree.com

OBJECTIVE

Seeking a position as senior database administrator (DBA) in SQL Server environment.

SUMMARY

10+ years of experience in SQL Server database administration including SQL Server 2005, 2008, 2012, 2014 and 2016.

5+ years of experience in deploying, administering and troubleshooting of SSIS, SSAS and SSRS.

3+ years of experience in logical and physical database design and writing T-SQL query and stored procedure, trigger.

1 + years of experience in SQL Azure and cloud platform.

2 + years of Experience in Oracle 10g database administration.

Experience in installation and configuration of SQL Server Always on, clustering, log shipping, mirroring and replication.

Experience in installation and configuration of SQL Server 2005, 2008, 2012, 2014 and 2016.

Experience in upgrade and data center migration of SQL Server instance and databases.

Working knowledge of Windows Server Administration, Sharepoint Service, Active Directory, Network and SAN.

Effective communication skills with all levels of management, both internal and external, as well as the ability to work in a

team environment. Perform all allocated tasks accurately and in a timely manner.

Sr. SQL Server DBA

Dallas County Government Aug 2018 - Present

Worked on SQL Server 2016 upgrade project. Installed 10 instance of SQL Server 2016 and moved 200 databases from

SQL Server 2012 to SQL Server 2016 instance. Migrated related jobs, logins and linked server. Setup alert and

maintenance task. Configured SQL Server for optimal performance. Migrated SSIS package from SQL Server 2012 to

SQL Server 2016 instance. Installed and configured SSRS. Deployed reports in SSRS.

Setup Always On availability group for county reporting application databases in 2-node Windows cluster, so the reporting

query can be done on secondary replica.

Setup 2 node active active SQL cluster in SQL Server 2016 instance.

Wrote PowerShell script to automate DBA task.

Troubleshooted and resolved database performance issues, blocking and deadlocking issues, replication issues, SQL cluster

issue, connectivity issues, security issues etc.

SQL Server DBA

Optum Technology Jul 2011 – Jul 2018

Dallas, TX

Worked as production and development support DBA for SQL Server 2016, 2014, 2012, 2008 R2 and 2005 of up to 4 TB

size database both OLTP and data warehouse. Performed installation, configuration and applied hotfix and service pack.

Lead data center migration from different domain. Upgraded several SQL server 2000 and 2005 instance to SQL Server

2008R2 and SQL 208R2 to SQL 2012 and from SQL 2012 to SQL 2016 instance.

Developed maintenance plan for backup (SQL native tool, Red Gate and DD Boost), index rebuild and cleanup task for

several databases. Created backup policy according to business need. Wrote PowerShell scripts to automate DBA tasks.

Troubleshooted and resolved database performance issues, blocking and deadlocking issues, replication issues, SQL cluster

issue, connectivity issues, security issues etc.

Performed database encryption for PCI/PII data using SQL 2016 always encrypted feature. Setup TDE (Transparent

Data Encryption) on SQL Server 2008 instance. Encrypted PII data using Protegrity on SQL Server 2012 instance.

Managed SQL Azure databases security. Moved several databases to SQL Azure from on premise using DMA (Data

Migration Assistant). Configured resources in SQL Azure environment.

Provided support for SSAE16 audit. Acted as prime contact person for database.

Deployed SSIS packages, SSRS reports and SSAS cubes on production server. Debugged and troubleshooted SSIS job

related issue. Took care of SSAS and SSRS security.

Created physical database model from logical database model using ERStudio. Applied DDL on development database.

Compared databases on production, test and development server using SQL Compare. Corrected data corruption issue

Using SQL data compare.

Setup Always On availability group for mission critical accounting databases and SharePoint 2013 firm in 3-node cluster.

Setup snapshot and transactional replication between production and reporting databases.

Setup 4 node active passive cluster in SQL 2012 environment.

Performed performance tuning, table partitioning, query optimization, using performance monitor, query execution plan

and other related monitoring and troubleshooting tools such as Spotlight.

Performed design and modification of database objects (tables, schemas, indexes, triggers, stored procedures and views),

SSIS packages and SSRS reports.

Participated on 24 X 7 on call support. Familiar with change management process. Used extensively ServiceNow.

Belo Corporation, Dallas, TX

SQL Server DBA Jan 2010 – Jun 2011

Dallas, TX

Installed configured and maintained SQL Server 2005 and 2008 for managing databases of 500-900GB of size for both

OLAP and OLTP in production environment. Upgraded from SQL Server 2005 to SQL Server 2008. Applied required

patches service packs and hot fixes.

Setup high availability options such as database mirroring in SQL Server 2005. Failover database mirror to DR server.

Setup high availability options such as database cluster in SQL Server 2008. Cluster was implemented in Windows 2008

clustered server using two node active passive.

Developed database maintenance plan for backup, integrity check and re-index. Performed database recovery operation

From backup file. Performed point in time recovery using transaction log backup.

Performed performance tuning using SQL Profiler for slow running quries and stored procedures.

Provide 24X7 on-call support for any database related issue.

Setup database audit in SQL Server 2008. Supported internal and external auditor for database audit.

Setup alert for Memory/CPU utilization and different Windows services whenever down using Solarwinds.

Performed as admin for Windows Sharepoint Server 2007. Used stsadm command to backup and restore

Sharepoint site. Extensively used central administration. Added sites and gave proper permission.

Administered SSIS server. Imported data from EXCEL and flat file to SQL Server database table using SSIS export import

wizard. Developed SSIS package for bulk insert.

Texas Instruments, Dallas, TX

Database Administrator/Developer

SQL Server 2005 and Oracle 10g Jan 2004 – Dec 2009

Responsibilities:

Supported a mixed environment of SQL Server 2000/2005 and Oracle 10g including installation, configuration,

performance tuning, patching, monitoring and backup and recovery of databases in OLTP production environment.

Setup high availability options such as database mirroring, log shipping and replication in SQL Server 2005.

Monitored SQL Server performance, SQL auditing, error logs, tuning T-SQL queries.

Troubleshooted SQL Server and Oracle 10g related issues.

Created database logins, users, roles and permissions in SQL Server 2005 and Oracle 10g.

Provide 24X7 on-call supports for database related issue for SQL Server and Oracle 10g.

Developed TI internal web pages using ASP.NET.

Broadcom Corporation Santa Clara, CA

Database Developer Nov 2001 – Dec 2003

Responsibilities:

Designed employee database for HR use. Analyzed business requirements and interviewed users and managers to identify

the information requirements. Build model of the system. Implement database in SQL Server 2000.

Develop relational data models both logical and physical using Erwin.

Wrote complex SQL query and stored procedure for Human Resource (HR) department.

Wrote Perl script to extract data from data log for ASIC design team.

EDUCATION

University of Texas at Arlington, Arlington, TX

Bachelor of Science in Computer Science and Engineering (BSCSE), 2001

SKILLS

Operating System: Windows VISTA/XP/2000/2003/2008/2012, UNIX and LINUX.

Programming Language: T-SQL, ASP.NET and PowerShell.

Tools: Management Studio, SQL Profiler, Database Engine Tuning Advisor, Visual Studio 2008, 2012, Red Gate, ERStudio, Control M, Spotlight, Data Domain Boost, Protegrity, Identity Manager and ServiceNow.

RDBMS: MS SQL Server (2000, 2005, 2008, 2012, 2014 and 2016), SQL Azure and Oracle 10g.

VISA STATUS

Citizen of the United States.

Contact this candidate