We provide IT Staff Augmentation Services!

Sql Developer Resume

Tulsa, OK

PROFESSIONAL SUMMARY:

  • I am an IT professional with 5+ years of progressive experience in the IT field. Work as a Data Analyst with a good working knowledge of SQL and Data Warehouse Platform.
  • I can work with SSAS, SSRS and SSIS. and other programming languages like MySQL and Microsoft SQL to complete work.
  • Also, proficient working with Agile and Scrum methodologies to accomplish project milestones according to specific time frames.
  • I am seeking a Data Analyst role in a growing company working with cutting edge technologies to apply my skills to build creative and flexible data pipelines that can rapidly evolve to handle Data and gain more hands - on experience.
  • Experience in writing SQL quires and creating SQL stored procedures from Scratch
  • Experience in transforming data using SSIS
  • Experience in other Business Intelligence, Data Transformation and Data Warehouses tools
  • Experience with reporting tools such as Domo and Tableau

TECHNICAL SKILLS:

Databases: MySQL SQL Server SSAS, SSRS AND SSIS .

SDLC: Scrum (Agile)

IT: Microsoft Office Suite (Excel expert) Tableau

Languages: Scripting (Linux) SQL

File types: Text XML JSON CSV

PROFESSIONAL EXPERIENCE:

Confidential, Tulsa, OK

SQL Developer

Responsibilities:

  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Designed the physical and logical data modeling design for development projects.
  • Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers from other developers to achieve maximum efficiency and scalability.
  • Installed, configured and maintained MS SQL Server Replication for production servers to provide high availability.
  • Implemented partitioning to handle tables with over 600,000 rows.
  • Created and developed stored procedures to handle complex business rules, history data and audit analysis.
  • Configured Mail Profile for sending automatic mails to the respective people when a job fails or succeed.

Confidential

SQL Developer/Financial Analyst

Responsibilities:

  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Implemented partitioning to handle tables with over 200 million rows.
  • Created and developed stored procedures to handle complex business rules, history data and audit analysis.
  • Created internal and external user groups to expand level of knowledge to assist clients.
  • Performed database backups for production, test and development servers and restored backups onto test servers to ensure that we had good backups.
  • Designed and implemented a disaster recovery system. Involved in disaster recovery procedures and restoring the production database.

Hire Now