Sql Server Developer

Sunil Mikkilineni

Phone No: - 419-***-****

Email: - ****************@*****.***

Summary:

• Over 14 Years of IT experience as Architect/DBA/Developer primarily in MS SQL Server and Microsoft Technologies.

• Over 10 years of experience as DBA/Database Modeler and Database Developer.

• Experience with working and leading a global team.

• Mentoring and tutoring junior team members.

• Experience with implementing HA and DR using Windows Cluster, DB Mirroring and log shipping.

• Excellent knowledge of database design fundamentals and the use of data modeling tools (ERD type tools), Like ERWIN, VISIO.

• Ability to understand to new systems and program new software in a short period of time.

• Good communication and analytical skills, as well as a good team player in understanding business functions, identifying sources of data, designing of reports to suite various needs of the end users.

Education:

Bachelors of Engineering (1993-1997) India.

Technical Proficiencies:

MS SQL Server 2000\2005\2008\2008 R2, SSAS, SSIS, SSRS, TSQL.

First solar Inc. Perrysburg, OH (Jan 2008 to till date)

Titles:-

Database Administrator.

Lead Database Administrator.

MIS Solutions Architect.

• Provided 24/7 support of MES Applications, Enterprise Applications (SAP, Peoplesoft, Sharepoint,CRM,Maximo, etc.), Internal Applications in 4 data centers located worldwide in 3 major offices, across 3 continents (N. America, EMEA, and APAC).

• Participated in monthly production maintenances and after-hours code deployments; worked closely with production DBAs to verify functionality and performance of post-deployment code

• Provided senior level support and guidance to other DBAs on the team as deemed necessary.

• Assigned tickets from the operational queue to other DBAs across the globe.

• Provided HA and DR using Microsoft & SQL Cluster, DB Mirroring and log shipping.

• Setup Transactional Replication.

• Integral part of many Disaster Recovery (DR) exercises including Standard SQL Backups, Log Shipping installations, Mirror Failover.

• Designed and implemented Database infrastructure for SAP using SQL Server 2008 with Mirroring for HA and Log shipping For DR.

• Upgraded SQL Servers from SQL 2005 to SQL 2008 with less/no service interruptions.

• Upgraded SQL Servers from SQL 2000 to SQL 2005 with less/no service interruptions.

• Setup SSRS using Active/Active load balanced architecture.

• Established standards for SQL installations, maintenance, tuning, and coding..

• Used system DMVs and functions to monitor and troubleshoot, to analyze the Index usage, I/O usage, CPU usage, etc.

• Implemented automated archiving for SQL Server to remove historical data from production OLTP systems.

• Researched, tested and oversaw production data server upgrades and database migration from SQL Server 2000-2005.

• Implemented many SQL Server 2005, 2008 and 2008 R2 Clusters (x64) in a Production/SAN environment.

• Implemented Multi Node \Multi Instance Windows Cluster

• Worked with the SAN Administrator for Storage Needs (HP 3PAR).

• Regular collaboration with remote development and QA teams

• Conducted root cause analysis for production database incidents and problems using fish bone and 5 why methods.

• Been involved with several Business Intelligence products using Analysis Services and Reporting Services.

• Lead many SQL projects in the performance analysis of several very large databases.

Ernst & Young Cleveland OH (August 2006 to Dec 2007)

Title:-

Lead Database Developer/Administrator

• Written and executed the Migration script to port Data from existing DB model to proposed DB model.

• Review code created by the developers to optimize the SQL ,Stored Procedures and Assist application developers with coding, performance, modeling, and design issues through production.(Applications were Created using C# and Ado.Net)

• Optimize query performance using Execution Plans.

• Database performance tuning for achieving high scalability and speed.

• Designing, creating the logical databases with the help of ERWIN.

• Involved in Capacity planning, sizing and database growth projections.

• Troubleshooting and optimizing using SQL Profiler.

• Design, develop and maintain Reporting solutions using MS Reporting Services.

• Design, develop and maintain SSIS Packages to accomplish ETL/Migration tasks

• Creating stored procedures, Views, User defined functions and Triggers using T-SQL.

• Creating complex stored procedures encapsulating the business logic at the database level using T- SQL.

• Created stored procedures to create reports.

• Created Triggers for audit purposes.

• Ad Hoc reporting Using T SQL.

Armanti Financial Services,NJ (January 2002 to August 2006)

Software Developer

Database Administrator

SSRS Reports Developer

• Designing, Creating the logical and physical databases with the help of ERWIN and VISIO.

• Involved in Capacity planning, sizing and database growth projections.

• Designing and Creating DTS Packages to accomplish ETL tasks.

• Created Data Transformation services (DTS) for transferring data’s from Pervasive 2000I, MS Aceess, and text files to SQL Servers.

• Install, configure and create prototype reports using Reporting Services.

• Design, develop and maintain Reporting solutions using MS Reporting Services, Crystal reports and MS access.

• Creating Stored procedures, Views, User defined functions and Triggers using T-SQL.

• Created complex stored procedures encapsulating the business logic at the database level using T- SQL.

• Created stored procedures to create reports.

• Created Triggers for audit purposes.

• Ad Hoc reporting Using T SQL

• Establish Change Management controls to ensure the integrity of the Development, Test, QA, and Production environments.

• Review code created by the developers to optimize the SQL ,Stored Procedures and Assist application developers with coding, performance, modeling, and design issues through production

• Optimize query performance using Execution Plans.

• Database performance tuning for achieving high scalability and speed.

• Create and Maintain Disaster Recovery Plans that supports all mission critical applications.

• Troubleshooting and optimizing using SQL Profiler.

• Set up and administer database security (creating new users, roles, profiles, etc.), Integrating SQL Server and NT Security, provide user privileges in development, test and production databases.

Environment :- Microsoft Technologies(SQL SERVER 2000,.NET ,C#,VB 6.0,MS Access,Pervasive 200I,Java,JSP)

Eplanets Inc, NJ (August 2000 to December 2001)

Software Developer

Database Administrator

• Installed and configured SQL Server 2000, service packs and hot fixes.

• Designing, Creating the logical and physical databases with the help of ERWIN.

• Creating Stored procedures, user defined functions and Triggers.

• Created complex stored procedures encapsulating the business logic at the database level.

• Created stored procedures to create reports.

• Created Triggers for audit purposes.

• Troubleshooting and optimizing using SQL Profiler.

• Set up and administer database security (creating new users, roles, profiles, etc.), Integrating SQL Server and NT Security, provide user privileges in development, test and production databases.

The position also included interacting with the client , translating needs into technical requirements, selecting the best implementation method, and Coding using JSP, JRUN 3.0, JAVA, Visual Basic 6.0

Contact this candidate