Database Developer Resume

SUMMARY

Having 4+ years of IT experience in Database Designing, developing and supporting with SQL Server (2012 and 2008R2 ) and Microsoft Business Intelligence (SSIS) .
Extensive experience with SQL Server and T - SQL in constructing Procedures, triggers, Tables, Table variables, user defined functions, views, indexes, CTE, temp tables, relational database models.
Good experience in optimizing the queries by creating various clustered, non-clustered indexes.
Good experience on Dynamic SQL (sp executesql, exec).
Good experience in import and export data using bulk insert and BCP commands.
Good in execution Plan, SQL Profiler to optimize queries and enhance the performance of databases.
Created different types of packages using control flow, data flow tasks on SSIS.
Worked on Data Flow Items Like Sources, Destinations and Transformations like sorting, merge, merge join and union all.
Hands-on experience in analyzing and troubleshooting SQL server processes.
Experience in using SQL Server Agent to Scheduling and Monitoring the Jobs.
Good knowledge in Admin related concepts like Backups, restores.
Good Experience with MySQL on writing queries and creating stored procedures.

TECHNICAL SKILLS

Tools: SSIS

Languages: T-SQL, SQL, MySQL

RDBMS/Data Bases: SQL Server 2012, 2008R2, MySQL

Operating Systems: Windows Server 2012/2008 R2

Other Tools: Toad, MySQL Workbench

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Environment: SQL Server 2012

Responsibilities:

Creating and Modifying Tables as per requirement.
Used Json to insert large data, and we convert the Json to table and then insert into tables.
Used Bulk Insert to import the data from flat/delimiter files.
Used BCP to Export the data from database to flat/delimiter files.
Created Insert/Update/Delete Triggers for audit tables.
Created jobs which meet the business requirements.
Created stored procedures using complex queries, dynamic queries, CTE’s, temp tables and user defined functions as per requirement.
Created Indexes to optimize the queries.

Confidential

Database Developer

Environment: SQL Server 2008 R2, SSIS

Responsibilities:

Creating and Modifying Tables as per requirement.
Used Json to insert large data, and we convert the Json to table and then insert into tables.
Used Bulk Insert to import the data from flat/delimiter files.
Used BCP to Export the data from database to flat/delimiter files.
Created SSIS Packages to move data from one server to another server.
Created jobs which meet the business requirements.
Created and scheduled Database Mails to employees and clients as per business logic.
Created stored procedures using complex queries, dynamic queries, CTE’s, temp tables and user defined functions as per requirement.
Created various types of MIS Reports as per requirement.

Confidential

SQL Server Developer

Environment: SQL Server 2008 R2, SSIS

Responsibilities:

Creating and Modifying Tables as per requirement.
Wrote the SQL queries, Stored Procedures and Views according to requirements.
Comparing two databases. And find the difference of those two databases, Make it same.
Optimizing the queries by creating various clustered, non-clustered indexes.
Generated the Reports Weekly and Monthly wise as per the Client Requirements.
Created Triggers to enforce data and referential integrity.
Importing the data from different data sources Using SSIS.
Created Various MIS Reports as per requirement.
Responsible for monitoring the Database Servers.

Confidential

SQL Server Developer

Environment: SQL Server 2008 R2, SSIS

Responsibilities:

Creating and Modifying Tables as per requirement.
Wrote the SQL queries, Stored Procedures and Views according to requirements.
Comparing two databases. And find the difference of those two databases, Make it same.
Optimizing the queries by creating various clustered, non-clustered indexes.
Generated the Reports Weekly and Monthly wise as per the Client Requirements.
Created Triggers to enforce data and referential integrity.
Importing the data from different data sources Using SSIS.
Creating Various MIS Reports as per requirement.
Responsible for monitoring the Database Servers.