Sql Server Developer

HIRAL RUDANI

New Jersey, 551-***-****, *************@*****.***

PROFESSIONAL SUMMARY

•3+ years of experience in SQL Server Developer 2008/2016

•Hands-on experience and strong understanding of Software Development Life Cycle (SDLC)

•Experienced in methodologies like Waterfall, Agile, Scrum and RUP.

•Extensive knowledge of ETL Tool Informatica, Database maintenance using SSIS, ETL jobs between MYSQL and MS SQL, Performance monitoring and tuning, Data Validation, Integration, Recovery, Security, backing up and designing of new database, Replication set up and configuration processes and Troubleshooting issues.

•Considerable knowledge in T-SQL Server 2012, 2016 reporting, triggers, recovery process, replication, stored procedure, raise error, statistics, security and data masking, Always ON Support and Always ON availability group – Log shipping, replication, clustering – failover clustering, transaction – different isolation levels and extended events – SQL Profiler, Job scheduling and executing TCL Statements.

•Experience in interacting with BA, developers, technical support & help them base line the requirement specifications.

•Experience in managing Oracle database administration assignments for diverse industry clients and to enhance database performance, restores, recovering procedures, handle performance tuning and conduct regular system backups.

TECHNICAL SKILLS:

Web Design/Development

HTML5, CSS, AJAX, Java Script

Cloud Platform

Microsoft Azure, AWS - Database Services, SharePoint

Data Management tool

Toad for SQL Server 6.8

Data warehouse

ETL Tool- Informatica

Software

OPNET Simulator, Visual Studio

BI Tools

Tableau, Power BI

Programming Languages

C, C++, ASP.NET C #, Java, Python

Project Management Tools

Rally, Jira, Bugzilla

Web Debugging Tool

Firebug, Firepath, XPath

IDE

Eclipse, Intellij.

Continuous Integration Tools

Jenkins, Hudson, Bamboo

Methodologies

Agile, Waterfall, V-Model

Databases

Couchbase,Cassandra, Oracle, DB2, Microsoft SQL Server 2008, Microsoft SQL Server 2016, MS Access, PL/SQL, MYSQL, PostgreSQL

Operating Systems

Windows, UNIX and LINUX

EXPERIENCE

Database Developer, Forever Collection DBA Nice Diamonds Inc., New York, NY August 2017- Present

•Configured and proactively monitored SQL Server database. Supported the developer in creating tables and indexes.

•Simplified the user interface by creating complex DB views and enforced data consistency through numerous triggers and stored procedures.

•Maintained PL/SQL Scripts and performed data warehousing with ETL

•Environment: SQL Server 2016, DEV

Database Administrator, Schneider Electric, India May 2014- September 2015

•Proactively monitored and maintained performance and availability of the database systems within the enterprise.

•Maintained SQL scripts indexes and complex queries for analysis and extraction.

•Worked with the Project manager, business owner, analyst teams and clients on building database prototypes to implement new enhancements.

•Created and evaluated the database management procedures

•Environment: SQL Server 2008, DEV, QA

Software Developer Trainee, Infinity Infoway, India May 2013 - May 2014

•A Trained and developed an ERP project using ASP.NET C# and SQL Server having MVC architecture.

•Generated a website through .Net by developing database for products through SQL Server 2008.

•Managed the purchasing, manufacturing and distribution of products.

•Monitored the database in order to avoid bad data situation, corruption and loss of data from database.

•Environment: ASP.NET C#, SQL Server 2008, DEV

ACADEMIC-PROJECTS

•Online Grocery Shopping System Database: It was based on Enterprise Resource Planning (ERP) System. The system provides detailed analysis of products. Co-ordination between the all other channel partner like dealer can place order from parent dealer and sell it to sub dealer and generate the billing report.

•Environment: ASP.NET C#, SQL Server 2008.

EDUCATION

Master’s in Computer Science, NYIT, New York, GPA 3.49/4.0 (May 2017)

Bachelor’s in Computer Engineering, Gujarat, India. GPA 7.50/10.0 (July 2014)

Contact this candidate