Sql Server Developer

NITIN SAHU

Flat No. ***, Mangalam Avenue, Anand bajar,Indore, Madhya Pradesh

Contact: +919*********; Email: ****.*********@*****.***

Objective: Seeking a challenging and rewarding opportunity with an organization of repute which recognizes my true potential and effectively utilizes/ nurtures my excellent analytical and technical skills.

PROFILE

•Over 4+ years of experience in analysis, design, development and deployment of SQL, MySql or Oracle 9i,10g

SQL Server DBA.

I have a sound knowledge of Procedure, Triggers, Cursors, Sql query Execution Plan, Normalize Database, Expertise in relational structure design and full system logic performance using key constraints. Strong knowledge of Scheduling Jobs, Backup and Recovery of Database.

•Installed and Configure SQL Server 2000, 2005, 2008,r2 in development, test, and production environment

•Installed, Configured and Maintained SQL Server 2000 and 2005

•Migrated databases from SQL Server 2000 to 2008r2 in test and production environment

•Writing T-SQL, Stored-Procedures, Trigger, Cursors, Functions (Tabular and Scalar), CDC (Change Data Capture)

•Performance tuning &index tuning

•Linked Server

•Assist SQL developers to optimize SQL queries and Stored Procedures

•SQL Server Error Log, space usage

•Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes

•Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database

•Ability to run script properly, Shrink database, knowledge of database migration procedure.

•Managed and maintained security issues by defining roles and permission on Table/Database/Server level.

•Data Migration From Other To SQL or Vice versa.

•Familiar with SQL Server 2005/2008/2012 concepts like Data Compression, Backup stream compression, Client/Server Connectivity, Database consistency checks, Index Tuning Wizard.Experience in supporting huge databases, troubleshooting the problems of Root cause analysis.

•Strong SQL Server Administration skills using various backup strategies, Recovery Model (simple, bulk-logged and full), database maintenance plan, user (NT/SQL) security authorizations.

•Good Experience in Database Backup, Recovery and Restoring as daily activities. Experience with SQL Server development and T-SQL in writing stored procedures, creating user defined functions, constructing triggers, tables, views, indexes, user profiles. Scheduling& Monitoring Daily Jobs, DB-Maintenance Plans, Run DBCC jobs for Re-indexing, Check-DB, Fragmentation across all the SDLC.

•Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.

•Experienced with SQL Server up gradation & Upgrade Advisor (In place & Side-by-Side) for large and mission critical applications from 2000/2005/2008/2008R2/2012

•Involve in Query Tuning by looking at Indexes, joins, coding standards with the help of Execution Plans, query plans SQL Profiler, DTA Performance tools etc.

Oracle DBA.

I have a sound knowledge of Procedure, Triggers, Cursors, Packages, Indexing, Constraints, SQL query Execution Plan etc Database Designing, Expertise in relational structure design and full system logic performance using key constraints. Strong knowledge of multiple table queries for customized complex reports with related sub-reports Usage of locks and multi layer transactions within stored procedures, triggers and functions. Query Optimization and troubleshooting

•Working On Oracle APEX Tool To design Application and Managing Database

•Managing Roles and Assign Privileges Of Database

•Implementation and maintenance of user security

•Installation of Oracle patches, performing backup and recovery procedures.

•Installed and Configure and Maintained Oracle 9i,10g,11g in development, test, and production environment

•Created Oracle Tables, Views, Constrains, Synonyms, Sequences.

•Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database

•Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.

•Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.

• Developed complex reports -- multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drilldown through On Demand Sub-reports, dynamic link labeling, complex functions, cross-tabs, charts, shared variables, imported parameters and record sets from stored procedures, conditionally suppressed sections, error handling/messaging, clean and attractive designs, user friendly with instructional ToolTips.

•Loaded the data using the SQL loader, Imports & UTL files based on file formats.

Additional Knowledge and Skill Areas:

•DB design and development

•SQL Server Administration

•Multi-language programming

•Technical Problem Solving

•Tuning Performance

•Data transfer, replication

•Transaction handling

•Advanced client reporting

•Project Management

•Strategic vision, and leadership

•Production Support / Consulting

•Teamwork & Communications

CERTIFICATION

The Oracle Certification Program AS AN Oracle PL/SQL Developer Certified Associate, Feb 24, 2010

Oracle Testing ID : SR6056032

PL/SQL 84.00%

SQL 75.68%

Good Command on procedure, Cursor and Triggers

EDUCATIONAL QUALIFICATION

Diploma in Advance Computing, 62%, 2011

Institute for Advanced Computing and Software Development (IACSD), Akrudi, pune

B.E (Electronics & Instrumentation), 61.03%, 2009

RishiRaj Institute of Technology and Science College, Indore

Class XII, 60.44 %, 2004

United Alpha English Higher Secondary School

Class X, 53%, 2002

United Alpha English Higher Secondary School

TECHNICAL SKILLS

Languages

PL/SQL, C#, C, C++, ADO.NET, XML

.NET Technologies

IIS Server 7.0

Frameworks

Asp.NET 3.5,4.0, Bootstrap 2.0

Client Side

JavaScript, jQuery,HTML,CSS3,Jquery UI

Client Side API

Google Map, Facebook, Twitter, eBay,Flipkart

IDEs/tools

Oracle APEX, Visual Studio 2008,2010,2012

Database Tool

Oracle SQL Developer, Sql Server 2008 Management Studio, My-SQL Workbench 6.2

Web Tools

JavaScript, HTML.

Database

Oracle 9i,10g/11g. OR SQL Server 2005,2008r2, MySql 5.5

Operating Systems

Windows (Major), Linux.Ubantu

PROFESIONAL EXPERIENCE

Company Name : EMAX Global

Address : 216,SunRise Tower, MG Road, Indore, Madhya Pradesh

Designation : Jr. Oracle Developer

Technology : Oracle 9i

Tool Used : Oracle Sql Developer

Working : Work on Remote Desktop To Analyzed Database Query and give better Solution

Experience : October 2009 to December 2010 (1 Year 2 Months)

Company Name: Asaus Technology

Address: 501, Alankar Point, Geeta Bhavan Indore

Designation: Associate Software Developer

Technology: C#, Asp.Net, Sql Server and Crystal Reports

Tool Used: Visual Studio 2008 and Sql Server 2008

Project – Karan Development, Sheetal Project, Satnam Transport ( ERP )

Experience: 4 Month

Company Name: Covetus Technology Pvt. Ltd., Indore, India

Address: 104 Bansi Trade Centre, Indraprasth Square

Designation: SQL DBA or C# Team Lead

Technology: C#, Asp.Net, Sql Server and Crystal Reports

Tool Used: Visual Studio 2008 and Sql Server 2008

Experience: 2012 April To Current

DECLARATION

I hereby affirm that all the information furnished above is true to the best of my Knowledge

Place : Indore (Nitin Sahu)

Contact this candidate