| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate1Candidate's Name
SQL Server Database Administrator (DBA)McLean, VAEmail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEUSAPROFESSIONAL SUMMARY Proficient in designing, coding, testing, and supporting database solutions in SQL Server(versions 2012/2014/2016/2017/2019), ensuring robustness, availability and scalability. Experienced in ETL architecture using SSIS, with data integration skills from diverse databases such as Oracle (12C, 11G, 19C), PostgreSQL, MongoDB, and DB2. Skilled in configuring and managing SQL Server in AWS RDS and EC2 environments, optimizing cloud-based database solutions. Demonstrated expertise in SQL Server upgrades, security implementations, user management, role assignments, enhancing database functionality and protection. Effective in deploying and managing databases across production, development, and test environments, adhering to ITIL best practices and change management protocols. Proficient in ensuring high availability and disaster recovery using Replication, Log Shipping, Database Mirroring, Failover Clustering, and Always On Availability Groups. Expert in performance monitoring, tuning, and troubleshooting, with a strong ability to identify and resolve database performance issues. Developed comprehensive backup and disaster recovery strategies, maintaining database integrity and minimizing data loss. Experienced in Microsoft Reporting Service (SSRS) for report authoring, management, and security, including the creation of complex reports and automated processes for database and reporting tasks.Tools: SQL servers, Oracle, PostgreSQL, AWS, Azure, SSIS, SSRS, SSAS, Replication, Mirroring, log shipping, failovers cluster, Always On, SQL Server Security (Always Encrypted, TDE), HIPAA and SOX Compliance, SQL Profiler, Redgate SQL Monitor, SolarWinds DPA, Indera SQL Diagnostic Manager, Apex SQL Monitor, JIRA, Team Track, ServiceNow 2WORK EXPERIENCE:Sr. SQL Database Administrator Jan 2022 -PresentTata consulting services Kaiser PermanenteRockville, MDResponsibilities: Managed and optimized SQL server database systems in an on-prem and AWS (RDS) environments, ensuring efficient data management and storage solutions. Troubleshot SQL Server-related issues, with a focus on testing and enhancing database performance, ensuring reliability and availability. Ensured compliance with HIPAA and SOX requirements, demonstrating a commitment to maintaining high standards of data privacy and security. Implemented additional security to protect PII and PHI data using Alway-Encrypted feature and TDE. Monitored and tuned system resources associated with database performance, specifically targeting I/O and disk resources to optimize system efficiency. Conducted server validation processes, ensuring that all hardware met required specifications and performance benchmarks. Involved in the patching process, applying critical updates to maintain system security and reliability. Installed and configured SQL Server environments, ensuring optimal setup and performance tuning for database applications. Managed the upgrading and migration of SQL Servers, implementing the latest features and improvements to enhance database functionality. Led migration projects to transfer data across different platforms, ensuring seamless transitions and minimal downtime. Architected nightly ETL process using SSIS and SSIS Catalog. Implemented Windows cluster across multiple availability zones and set up SQL Server 2016 Always On availability groups in AWS, enhancing database availability and disaster recovery capabilities. Ensured the implementation of best security practices, access controls, and permissions for database servers to maintain data integrity and confidentiality. Employed performance tuning and query optimization techniques to ensure efficient database operations, including the use of execution plans, trace flags, and SQL Profiler. 3Sr. SQL Server DBA Feb 2020 Jan 2022Tata consulting services McKessonRockville, MDResponsibilities: Installed, configured, and secured production and non-production SQL server instances, including both clustered and non-clustered environments. Led the migration process from Oracle databases to SQL Server 2017. Installed and configured Oracle 19C showcasing proficiency in managing diverse database technologies. Managed the upgrading of SQL Server from 2012 to 2016 and 2017, demonstrating expertise in database version control and system optimization. Established database transactional replication for reporting servers and automated database refresh processes as per business requirements, optimizing data availability and performance. Spearheaded SQL performance tuning initiatives, identifying and resolving locking and blocking issues to improve database performance significantly. Developed and managed Ola Hallengren's SQL server maintenance plans, scheduling routine tasks to ensure system reliability and efficiency. Handled SQL Server logins, database users & roles, and daily user maintenance, maintaining optimal database access and security. Created and scheduled database maintenance jobs for full and transaction log backups, using SQL Server agent job scheduler to ensure data safety and recoverability. Configured database mirroring for disaster recovery, ensuring high availability and data protection. Provided weekly status updates on all projects to the Project Manager, facilitating transparent and effective communication. Developed, debugged, and optimized stored procedures, triggers, and functions in T- SQL based on client requirements, enhancing application functionality and database performance. Designed and executed ETL processes using SSIS to load data from various sources, including MS Access, SQL Server 2014, and Oracle databases, showcasing strong data integration skills. Conducted regular database backups, refreshes, and restores, alongside updating statistics and performing clean-up tasks to maintain optimal database health and performance. Supported AWS database environments in both production and development settings, demonstrating versatility in cloud-based database management. 4SQL Server Database Administrator May 2015 -Feb 2020 John DeereChicago, ILResponsibilities: Installed and configured various editions and versions of SQL Server in standalone, and clustered nodes. Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2008, 2008R2 & 2012. Applied service packs, hotfixes and cumulative updates. Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2012 and 2014. Created and maintained logins, Users, Roles and managed security of the database. Taking Full, Differential and Transactional log backups and setting automated jobs. Utilized SSIS and SQL Agent jobs for scheduled data import and export operations (ETL) Performed data Extracting, Transforming and Loading (ETL) from different data sources. Rebuilding/reorganize indexes to reduce fragmentation and enhance SQL server performance Created triggers, views and stored procedures, Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail. Utilized Resource Governor to control and allocate CPU and memory resources depending on the priority of applications. Configured and Managed Database High Availability solutions: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group. Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports Worked in team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team. Collaborated with Microsoft and other vendors for product and technical support. Processed assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet deadline before SLA is due. Experience in Agile projects with a solid foundation in Software Development Lifecycle(SDLC). |
