SUMMARY

• Highly experienced and Microsoft certified database professional with over 14 years of full - cycle experience in designing, planning, architecting, modeling, developing, managing, and maintaining multi-tiered database solutions in on-premise as well as cloud environments.

TECHNICAL SKILLS

Applications: MS Office Suites, MS Visual Studio, MS Visual Studio Code, MS Visio, JIRA, Bitbucket, Bamboo, ArcCatalog, ApexSQL Suites, MS SharePoint, Postman, Git

Database: SQL Server, SSIS, SSRS, SQL Server Management Studio, Teradata, Netezza, MySQL, PostgreSQL, pgAdmin, Informatica, Power BI, PowerShell

Cloud: Microsoft Azure, SQL Database, SQL Managed Instances, Synapse, Azure Data Studio, Azure CLI, Data Factory, Key Vault, Azure Storage Explorer, Storage Accounts, Virtual Desktop, Virtual Machine, Function, Azure Active Directory, App Services, Azure CLI, Azure DevOps, Containers, VNET, Subnet, NSG, Route Tables, Logic Apps, Load Balancer, CDN, Recovery Service Vaults, Microsoft Defender for Cloud

PROFESSIONAL EXPERIENCE

Lead Cloud Engineer

Confidential, Silver Spring, MD

Responsibilities:

• Design, architect and maintain enterprise-level cloud solutions based on IaaS, PaaS and SaaS capabilities using teh best practices for cloud computing, reusability and cost optimizing techniques
• Analyze requirements, develop architecture, design artifacts, and execute application and data migrations from on-premises data centers to Azure
• Deploy, provision, and manage multiple Azure infrastructure components, including but not limited to virtual networks and subnets, virtual machines, web applications, databases, containers, functions, storage, Azure AD, RBAC, Key Vault, VDI, policies, alerts, logging, and monitoring
• Implement modern data solutions with Azure SQL Database, PostgreSQL, MySQL, Managed Instance, Serverless, Elastic Pool, Data Factory, Data Lake, Data Bricks, Azure Synapse and Power BI
• Monitor Azure cloud-based systems for availability, performance, reliability, and security using tools like Azure Monitor, Azure Log Analytics, App Insights and Microsoft Defender for Cloud
• Establish a continuous improvement plan for Cloud Operations, including technology reviews, root cause analysis, action reports analysis, and cloud portfolio review to ensure adequate infrastructure
• Ensure that teh cloud design is adhering to required standards, backup, restore, high availability and DR requirements and organization-based compliance needs

Principal Database Administrator

Confidential, Silver Spring, MD

Responsibilities:

• Designed, developed, implemented, and maintained enterprise-level Data Management Systems for NOAA Coastal Services Center on a multi-tiered SQL Server clustered infrastructure
• Provided expertise in all aspects of database administration, including installation and configuration, capacity planning, performance tuning, backup, disaster recovery, security, monitoring, software maintenance and upgrades
• Implemented data models, database designs, data dictionaries, tables, views, stored procedures, functions, triggers, and jobs per business needs
• Developed SSIS packages to support ETL processes and create SSRS packages to leverage enterprise-wide reporting solutions
• Developed REST API using Open Data Protocols on C# .Net framework to support teh development of data rich Geospatial Information Systems
• Installed, configured, administered, and maintained multiple SharePoint 2016 environments that host several mission critical sites and applications
• Configured and automated CI/CD pipeline (DevOps) for database deployment process using Bitbucket, Bamboo, and Docker Container
• Developed and promoted data management methodologies, standards and policies to ensure teh security and integrity of teh databases

Technical Database Lead

Confidential, Columbia, MD

Responsibilities:

• Led a team of five or more highly skilled database professionals to design, implement and maintain multi-terabyte CRM database solutions for teh clients
• Performed data profiling, data modeling, and data architecture design of a database solution and acted as subject matter expert in data management practices
• Created, updated and modified stored procedures, SQL scripts, DTS/SSIS packages, SQL jobs, views, functions, triggers etc.
• Analyzed database functionality for continual improvement and enforced best standards and practices for data analysis, data quality, and data transfer into an enterprise scale database environment
• Designed and developed test strategies, test plans, test cases and other test specification documents to ensure data consistency, data accuracy and data integrity
• Developed and maintained technical specifications, high-level designs and end user documentation of assigned projects and analysis
• Provided leadership and guidance to coach, motivate, and lead team members to their optimum performance levels and career development

Senior Database Developer

Confidential, Bowie, MD

Responsibilities:

• Designed, coded, tested and debugged stored procedures, functions, triggers and custom queries using Microsoft SQL Server according to teh defined technical specifications
• Performed data hygiene, data cleansing, data profiling, data analysis and data quality of various healthcare products
• Managed teh extraction, transformation, and loading of data files into clients’ databases
• Evaluated teh existing data model designs and proposed improvements to enhance teh overall efficiency and productivity of teh products
• Established a data quality methodology by documenting standard processes to define, maintain, and resolve data quality audit procedures
• Worked collaboratively with Business Analysts to write process specifications and update data dictionaries
• Acted as a mentor to junior team members, defined and enforced standard coding practices

Database Developer

Confidential, Alexandria, VA

Responsibilities:

• Designed, developed and implemented database architectural solutions on SQL Server 2000 and 2005 for 300+ clients to support and facilitate their political campaigns, grassroots and public affairs strategy
• Performed data analysis, data profiling and data quality checks on membership data, non-profit data, and data from different verticals prior to loading them into teh database using DTS and SSIS packages
• Participated in requirement gathering, design review and development planning to evaluate estimation of effort for design and development tasks
• Maintained and updated documentation of existing systems as needed to ensure accurate content and issue identification for ongoing support
• Participated in and contributed to process and procedure improvements in support of overall role, department, and organization strategies and objectives
• Provided guidance and training support to clients on use and functionality of various services and applications
• Carried out database performance tuning, optimization and troubleshooting periodically