| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Takoma Park, MD Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESummaryAccomplished and qualified IT professional with diverse and extensive on-premises and Azure cloud database administration experiences.An effective team member, including work as a Senior Microsoft SQL DBA, database design, and system administration using Microsoft SQL Server 2012,2014,2016,2017 and 2019.Experienced in the MS-Azure Cloud environment from design to Administering Azure SQL Databases. Key strengths include: problem-solving skills, attention to detail, multitasking, and the ability to build effective business relationships, even during times of high stress deployments.Extensive project management experience and process oriented; deeply experienced in providing solutions to performance issues. Equipped with an excellent work ethic; possesses a strong sense of responsibility and teamwork with a track record of dependability.Possess excellent verbal, written and presentation skills. MS-SQL Server Experiences A Microsoft SQL server (DBA) with 9+ years IT experience: designing, coding, testing, and supporting next-generation database solutions in SQL Server environment.Possess strong communication and problem-solving skills developed through a variety of projects. Offer proven ability in team work and proactive system support.Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2012, 2014, 2016, 2017 and 2019 versions. Good experience in configuring the SQL Server in AWS Relational Database Management system and in EC2.Extensive Experience in Upgrading SQL Server (In place Up and Side by side Upgrade) based on application compatibility and fixing the orphan users. Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users. Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tool.Good experience implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG. Strong experience on understanding and creating the server level and database level roles as per business requirement.Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans,Database Mail Configuration, facets and Transparent Data Encryption. Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues. Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.SkillsWindows Server OS, SQL Server, T-SQL,Red-gate SQL Compare 10 and Data Compare 10,AWS-RDS, AWS-EC2, IDERA SQL diagnosticDataEdo, ERWIN, SSDT, Azure, SSIS, SSRS, Manager, SQL safe 6.0 SSMS, DTA, JIRA, RAID, MYSQL,AZURE VM, Azure managed instance, MuleSoft, Salesforce, API.ExperienceAzure/SQL Server Database Administrator 06/2019 to Current CVS Health Woonsocket, RIAzure cloud professional with strong experience in migrating resources to Azure, Azure Adminstration, Azure infrastructure Operations, and end to end Project Managment. Produced high-standard database solutions to meet stability, reliability, Bash and PowerShell.Migrate SQL-Server Databases to Microsoft Azure hosted DBs, Managed instancesPerformed Database Migration from On-Premises SQL environment to Azure Database in cloud Managed database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent.Managed Servers and database level Security by implementing the Triple As (AAA); Authentication,Authorization and Auditing. All Users are Authenticated through the various security protocols.Participate in an on-call support rotation and provide non-standard work hour supportProvides database support to business users. Restores functionality to database processes that have failed, documents resolutions, and creates and maintains troubleshooting documentationEmploys general SQL, Microsoft T-SQL, stored procedures, Date Transformation Services (DTS) scripts, and SQL Server Integration Services (SSIS) to manage database systems and to automate data migration and processingDesigns, develops and implements database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications. Communicates with IT management, and peers regarding database solutions and potential enhancementsDesigns, develops, tests, documents, and implements scripts to automate data importing, exporting, reporting, and analysis to ensure data confidentiality, availability and integrityInstalling, configuring, administering and securing production and non-production servers (clustered and non-clustered).Upgrading SQL server 2016 to SQL Server 2019Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2016 Always On availability group in AWS.Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance.Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.Monitor database growth activities & Troubleshoot Transaction Log Issue. Created and configured mirroring for Disaster RecoveryProviding weekly status information on all projects to Project ManagerWrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements. Logical and Physical design of database for projects on basis of user requirements using ERWIN Reporting on a weekly basis to the project manager.Extensively worked on troubleshooting and fine-tuning of databases for optimal performance. Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler Installation of Service packs to all environments.Environment: SQL Server 2012-2019, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, DataEdo, ERWIN.SQL Server Database Administrator 02/2016 to 05/2019 Kellogg Michigan, MIInstalled and Configured various editions and versions of SQL Server in standalone, and clustered nodesInstalled, and Configured SQL Server Fail-Over Cluster for SQL Server 20014 & 2016Applied service packs, hotfixes and cumulative updatesUpgraded SQL Server 2012 R2 Database into SQL Server 2014 and 2016Created and maintained logins, Users, Roles and managed security of the databaseImplemented Disaster recovery plan by performing routine backups and restoreTaking Full, Differential and Transactional log backups and setting automated jobsMigrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/AttachPerformed data Extracting, Transforming and Loading (ETL) from different data sourcesRebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performanceCreated triggers, views and stored procedures,Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database MailHands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored proceduresWorking with Resource Governor to control and allocate CPU and memory resources depending on the priority of applicationsConfigured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability groupScheduled reports using SSRS to generate daily, weekly, monthly, quarterly reportsWorked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning teamExperience in contacting Microsoft and other vendors for product and technical supportProviding resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is dueExperience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC)Environment: SQL Server 2008, 2014, IDERA SQL diagnostic,, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.SQL Server Database Administrator 09/2014 to 02/2016 Mastercard New York, NYDatabase High Availability: Installed, Configured and Maintained AlwaysOn High Availability Group using SQLServer 2012.Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008. Installed,Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2012. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.Database Upgrade: SQL Server SQL Server 2008 R2 to SQL Server 2012Database Migration: Migrated MS Access 2012 R2 and 2014 database into MS SQL Server. Migrated Oracle 10g, MySQL into MS SQL Server 2012.Data Modeling: Worked on more than 10 data modeling projects and generated E-R Diagrams. Data Modeling tools used using SQL Server Data Diagram.Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, space usage.Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.Export & Import: Data from Oracle and SQL Server Excel and setup and performed ETL data load from Oracle and other flat files like text, Excel, and CSV filesBackup/Recovery: Proficient in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.Report Development: Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0.Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well.Environment: SQL Server 2012 - 2014, SQL Server 2012 SSMS, Profiler, Extended Events, Perfmon, RAIDEducation and TrainingBachelor of Science: Computer Science 08/2009Unity UniversityCertificationsCertificate in MCDBA: Administering Microsoft SQL Server 2012/2014 (70-462)Microsoft Certified: Azure Database Administrator Associate: DP-300 |
