Post Job Free

Resume

Sign in

Database Administrator Sql

Location:
Maryland
Posted:
March 22, 2024

Contact this candidate

Resume:

Objective: Dedicated and experienced Azure engineer / SQL Database Administrator with a strong background in managing and optimizing systems. Seeking a challenging role to leverage my expertise in Azure and SQL administration and contribute to the success of a dynamic organization.

Skills:

●Azure Cloud Services: Azure Virtual Machines, Azure Virtual Networks, Azure App Services, Azure Storage, Azure SQL Database, Azure Functions, Azure Active Directory, Azure DevOps, Azure Monitor, Azure Security Center.

●Infrastructure as Code (IaC): Azure Resource Manager (ARM) Templates, Azure CLI, Azure PowerShell, Terraform Networking: TCP/IP, DNS, VPN, Load Balancing, Firewall, network Security Group (NSG), ExpressRoute

●Security: Azure Security Center, Azure Active Directory, Azure Key Vault, Azure Firewall, Azure RBAC, Security Best Practices, Security Auditing, Threat Detection and Remediation

●Operating Systems: Windows Server, Linux (Ubuntu, Red Hat) Collaboration and Communication: Stakeholder, Management, Technical Leadership, And Documentation

●DevOps: CI/CD pipelines, Infrastructure as Code (IaC), Git, Qlik, UI design, Azure DevOps, AKS, Jenkins, Spark, CI/CD Azure Migrate & Data Migrate: Conducted an inventory of servers, databases, applications, and their dependencies for migration readiness

●Discover; assess; Replicate and Migrate; Azure Data Studio Replication: Use Microsoft peering to route replication traffic through an ExpressRoute circuit to Azure.

●Language: JavaScript, Python.

Work Experience:

Chewell group, Inc. Azure Engineer 05/2017 – PRESENT

●Designs cloud and hybrid solutions that run on Microsoft Azure, including compute, network, monitoring, storage and security.

●Administers AD and AAD support services such as AAD Conditional Access Policies, AAD Self-Service, Password Reset (SSPR, MFA) AAD Connect and Windows Server DNS

●Experience with Infrastructure as Code, automation, CI/CD, and DevOps practices, migrating workloads to Azure

●Possesses a mastery of architectural principles of cloud-based platforms including SaaS, PaaS, multitenancy, multi-tiered infrastructure, etc.

●Creates Shell and Python Scripts to automate creation of AMI's through preboot and bootstrapping techniques.

●Remote administration and system configuration through scripting, Linux CLI (Bash, Perl, and Python), SaltStack (Puppet), and Rackspace (OpenStack) console.

●Stays current with the latest Azure technologies, trends, and best practices.

●Acts as a technical lead, providing guidance, mentorship, and training to junior team members. Design, implement, test, and maintain big data solutions using Databricks; Data Factory (ADF)

●Designs and develops high-performance Databricks jobs for data transformation cleansing and enrichment Integrate.

●Experience with the Azure Ecosystem (Azure Data Lake, Azure Data Factory, Azure Data bricks, Azure Power BI, Azure Cognitive Services, Azure Storage).

●Working knowledge on Azure creating, configuring and managing VNets, Security groups, Availability Zones/Sets, Express Route, Virtual Machines (VM), Web App -- APP Service, Azure SQL ARM, SSIS and Azure Data Factory.

●Migrates on-premises workloads to Azure cloud based on the requirements set and approved by the management.

●Azure network experience, VPN and Express route, Azure DNS, Traffic manager and Load Balancers (LB).

●Responsible for systems and application performance monitoring, ensured the availability, performance, scalability and security of the production systems.

●Configures and troubleshoots VPN connections such as Site to Site, Point to Site, VNet to VNet and VNet Peering.

●Works with development teams to help engineer scalable, reliable and resilient software running in the cloud.

●Possess and apply strong verbal and written communication necessary for a dynamic nature of collaboration with customers, vendors, stakeholders and other engineering teams, solving complex business problems together.

●Evaluates & builds different compute frameworks for all tiers.

Chevy Chase bank. Database Administrator 02/99–01/03

Dunbar Armored, Inc. Database Administrator 02/04 – 08/17

●Proficient in database design, deployment, monitoring, and maintenance on Azure cloud Extensive knowledge of Microsoft SQL Server Database, and related technologies.

●Strong expertise in performance tuning, query optimization, and troubleshooting database issues.

●Skilled in implementing security measures and ensuring data integrity.

●Experienced with automation and scripting using PowerShell and Azure CLI.

●Excellent communication and teamwork skills, with a proven ability to work in a collaborative environment.

●Created and maintained documentation, including standard operating procedures, troubleshooting guides, and best practices to support knowledge sharing and ensure operational continuity.

●Developed and optimized T-SQL scripts, stored procedures, triggers, and views to support application development and data manipulation.

●Designed and implemented database security measures, including user management, role-based security, and encryption, to protect sensitive data.

●Managed and administered Sql server databases, including installations, backup and recovery, performance tuning and security.

●Designed and implemented highly available database solutions using technologies such as always-on availability groups, database mirroring and clustering.

●Experienced with SQL Server Integration Services (SSIS), Policy Management & performance tuning/optimization Good working experience of T-SQL (Indexes, Triggers, Functions, Packages and Procedures) Strong experience with SQL Server 2012/2014/2016/2017 and SQL Server 2019.

●Experienced with Windows Servers & AD, linked Servers and Aliases.

●Knowledge of human resource management and the ability to manage store personnel relating to recruitment, selection, training, development, motivation, retention, and separation.

●Bolstered overall productivity by 30% by analyzing departmental needs and aligning it with business objectives.

●Spearheaded a team of 30+ employees & trained them on hardware & software installation, configuration and maintenance.

●Led 15+ projects and ensured that the deadlines were successfully met to improve client satisfaction.

●Conducted in-depth technical reviews of new and existing IT environments to identify the appropriate mitigation strategies required to bring these systems into compliance with established policy and industry guidelines.

Certification:

●Microsoft Azure Administrator

EDUCATION AND TRAINING

●University of the District of Columbia; Master’s Degree in Urban & Regional Planning 1995

●Microsoft Azure cloud engineer Master’s program



Contact this candidate