We provide IT Staff Augmentation Services!

Database Manager Resume

SUMMARY

  • Over 7+ years of IT Professional experience in development of applications built on Microsoft SQL Server 2008/2012/2014/2016 and Postgres 11/12.
  • Hands on experience on Azure SQL, AWS EC2/RDS instances and web apps.
  • Automate backup & recovery, patching, maintenance and performance tuning of SQL and Postgres databases.
  • Hands on with High availability/Multi AZ,Read Replicas and disaster recovery planning and configuring for SQL Server and AWS RDS instances.
  • Good experience with building database security using TDE, EBS volume encryption, KMS in AWS.
  • Hands on migration experience with SQL server and Oracle on prem to RDS Postgres using AWS SCT and DMS.
  • Expert in AWS Database technologies like AWS Aurora, RDS, Redshift,Dynamo and Neptune.
  • Hands on experience with Big Data open - source technologies such as Hadoop, HBase, Spark, Kafka and ElasticSearch
  • Strong Experience in SSIS,SSAS and SSRS .
  • Highly experienced in ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using SSIS .
  • Performance tuning of SQL/Postgres servers and SSIS packages for handling transactions at high volume.
  • Expert in writing SQL Queries and Stored Procedures for reports and ETL processes and Query Optimization .
  • Proficient with python and C#, .NET framework/Core.
  • Optimize, tune and enhance the SQL /Postgres database performance by using Performance Monitor, DMV’s, QueryStore,Execution Plans and AWS CloudWatch and RDS Performance Insights.
  • Expert in design of Star and Snowflake Schemas for data warehouse database.
  • Excellent Knowledge in developing and modifying multidimensional cubes using SQL Server Analysis Services (SSAS).
  • Proficient in creating robust interactive dashboards, drill through reports, KPI’s for sales and operation managers using Power BI
  • Publish reports/dashboards to Power BI cloud and manage user groups and permissions (row level and report level)
  • Expert in developing parameterized, drill down and aggregation reports with cascading parameters, filters-user friendly dropdowns, text boxes in MS SQL environment using SSRS .
  • Predict company financials using machine learning time series and neural network algorithms.
  • Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, Python 3.5/3.6

Database: MS-SQL Server 2008/2012/2014/2016 , MySQL

Tools: SSIS, SSAS, Power BI, SSRS, Tableau, Visual Studio 2012/2013/2017 , Microsoft Test Manager, MS Visio,SSMS, Lucid Charts, VSTS, Rapid Miner.

Environment: Microsoft Azure, AWS.

Methodologies: Waterfall, Agile and Scrum.

OS: Windows Server 2012,2016,2019

PROFESSIONAL EXPERIENCE

Confidential

Database Manager

Responsibilities:

  • Manage SQL, Postgres and Mongo database servers located on perm, AWS EC 2, RDS and Azure environments.
  • Migration of SQL Server databases and applications to AWS EC2 instances
  • Migration of MS SQL, Oracle servers and applications to RDS Postgres Serverusing AWS SCT and DMS.
  • Automate backup & recovery, patching, maintenance and performance tuning of SQL and Postgres database.
  • High availability/Multi AZ, read-replicas and disaster recovery planning and configuring for SQL Server and AWS RDS Instances.
  • AWS EBS volume encryption
  • Hands on experience on creating virtual machines, VPN, Azure SQL, AWS RDS instances and web apps on Azure and AWS.
  • Active Directory integration to Postgres for better managing security around AD users and groups.
  • Master Data Management, data governance and data quality.
  • Performance improvement for SQL and Postgres servers: Index level, Query level, and server level.
  • MDM to maintain golden records for the data models used across applications
  • Maintain strict rules around Dev/ Test/UAT and Prod environments.
  • Solid documentation and ensure all code is on GitHub before any project gets deployed to production.
  • Manage database team in US, Russia and India.
  • Organize Projects per epic/story and tasks in Jira.
  • Involve in sprint planning, ensure stories/tasks are prioritized according to business requirements and dev team capacity.
  • Organize deployments to ensure stable releases on a continuous basis
  • Use Jenkins CI/CD pipeline to do app/database deployments.

Environment: MS SQL Server 2016, Postgres 11, Cosmos Mongo db, MuleSoft, Microsoft Azure, AWS RDS, SSIS, Tableau, SSRS, SSDT, GitHub, Jenkins, C#, .NET Core, Python 3.5 Visual Studio 2019, Windows Server 2019.

Confidential

Database Developer

Responsibilities:

  • Design database diagrams, develop and maintenance of SQL Server databases to support data related assessments, patients, diagnosis and lab results and client data.
  • Design, develop and maintain a wide range of ETL workflows using SSIS.
  • Parent-Child configurations, scheduling sequences of SSIS packages using SQL Agent.
  • Work with different data sources: txt with different delimiters, excel, xml, json and efficiently bring data in databases
  • Write complex stored procedures to generate dynamic columns on the fly, using SQL Server 2016 functions to read json and export them to normalized tables.
  • Maintain all development work in GitHub repos.
  • Build and maintain financial and accounting reports using SSRS.
  • Develop .net core applications to meet the database related requirements.

Environment: MS SQL Server 2016, Postgres 11, SSIS, Tableau, SSRS, SSDT, VSTS, C#, .NET Core, Python 3.5 Visual Studio 2017, Windows Server 2016.

Confidential

Database Administrator

Responsibilities:

  • Maintain Server level and database level security and permissions for the internal users.
  • Create weekly maintenance plans to ensure the database server is up and running clean all the time.
  • Identify performance bottlenecks on the SQL Server and resolve them for optimal performance of the server.
  • Redesigned and developed the whole database to make the overall performance of the server better. Performance increased up to 70%.
  • Maintain the jobs and job schedules in SQL Server Agent and windows task scheduler.
  • Implemented Row Level Security on different tables to limit row level access to users.
  • Setup in Memory OLTP tables for fastest data retrieval on the tables of regular use
  • Automating the data uploads to the database with data files coming daily and weekly through SFTP, FTP, FTPS .
  • Worked with python- report lab to generate pdf reports from the data coming from the database and email them to respective parties daily and weekly. Thus, by saving 1.5 man’s work every day.
  • Currently working on GAP analysis within the servicing, secondary marketing, shipping, closing and post-closing teams to identify the gaps, manual process and streamline the gaps, automate most of the manual processes.
  • Expert in Web Scraping with modules Selenium and Beautiful Soup using python .
  • Created .net core console apps to automate MERS registration which saves 100 hours of work every month.
  • Call vendor Rest API to get the data and load it to the database using python http requests.
  • Implemented Dynamic Data Masking to Mask the columns containing sensitive data
  • Design and deploy Incremental loads packages using SSIS.
  • Create dynamic interactive dashboards using Power BI and publish to Power BI cloud.
  • Create DAX queries and measures to transform to the reports needs in Power BI.
  • Use Power Query, Power Pivot, Pivot charts to create drill down/drill through reports in Power BI.
  • Manage user groups and permissions (row level and report level) to access Power BI reports
  • Building Machine learning algorithms to predict the company revenue for the next 3 months.

Environment: MS SQL Server 2016, Microsoft Azure, SQL Server Integrations Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Data Tools, VSTS, C#, .NET Core, Python 3.5 Visual Studio 2017, Windows Server 2012 R2.

Hire Now