Database Engineer Resume

TECHNICAL SKILLS

Languages: T - SQL, Python, HIVE, Spark, Impala

Database: Microsoft SQL Server, PostgreSQL, HDFS, MySQL

Other: Visio, Git, Tableau, HTML, Anaconda, MongoDB, VMWare, Active Directory, Agile, SSIS, SSRS, OLAP, ETL (Pentaho Kettle), AWS (EC2, S3, RDS), Cursors, Axure.

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer

Responsibilities:

Designed, Deployed and maintained internal employee time sheet application using Microsoft CRM and SQL Server.
Developed & maintained custom SQL stored procedures & ad - hoc reports to assist with global finance, HR & IT reporting requirements.
Provide technical assistance to the development team, fix errors, review code & apply best practices.
Developed highly efficient re-runnable scripts to have robust backup & point in time recovery strategies across multiple data centers.
Designed and Implemented an Enterprise data warehouse through logical modeling, database design, data sourcing, loading & transformation, end-user tools, SQL & ETL procedures to process multi-terabytedatafrom multiple sources.
Created cubes in SSAS to retrieve/filter & drill-down data used in analysis/reporting.
Parse JSON and XML data using Python.
Lead standups, sprint reviews & sprint planning sessions to draft technical specifications, understand requirements & limitations in architecture and provide right timelines in delivering a finished product increment.
Create Tableau visualizations of underlying data trends that can be accessed by leadership to make better business decisions.
Periodically checked all databases with DBCC commands for maintaining data consistency, integrity and fix data corruption.
Hands on experience of big data technologies such as, Hadoop/HDFS/Hive & ETL tools like Pentaho Kettle.

Confidential

Senior Analyst

Responsibilities:

Developed and maintained database tables, views &stored procedures to handle business logic and module functionality for client application-Gemini.
Responsible for store order fulfilment and replenishment projects for IKEA (North America) via Gemini.
Created re-runnable SQL build scripts, using DDL & DML to be executed on various environments for populating required tables, views and facilitate efficient data manipulation.
Setup Transactional, Snapshot & Publisher- Subscriber replication for high availability across different environments.
Hands on experience in debugging database integrity issues, blocking and deadlocks.
Experience with performance tuning, query optimization using SQL Query analyzer, SQL profiler & other monitoring tools.
Performed bug fixes, re-factored inefficient code to debug production ETL issues
Strong analytical and problem solving skills coupled with interpersonal and leadership skills.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship