New Jersey, 551-***-****, email@example.com
•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.
HTML5, CSS, AJAX, Java Script
Microsoft Azure, AWS - Database Services, SharePoint
Data Management tool
Toad for SQL Server 6.8
ETL Tool- Informatica
OPNET Simulator, Visual Studio
Tableau, Power BI
C, C++, ASP.NET C #, Java, Python
Project Management Tools
Rally, Jira, Bugzilla
Web Debugging Tool
Firebug, Firepath, XPath
Continuous Integration Tools
Jenkins, Hudson, Bamboo
Agile, Waterfall, V-Model
Couchbase,Cassandra, Oracle, DB2, Microsoft SQL Server 2008, Microsoft SQL Server 2016, MS Access, PL/SQL, MYSQL, PostgreSQL
Windows, UNIX and LINUX
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
•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.
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)