Home

Ravi B - MS SQL DBA

[email protected]

Location: Salt Lake City, Utah, USA

Relocation:

Visa: H1B

Ravi Email: [email protected] Contact No +12542734015 Objective To contribute to a dynamic organization where I can apply my extensive expertise in Information Technology, particularly in database management and cloud solutions, while embracing opportunities for personal and professional growth. Profile Summary I am an accomplished MSSQL Server Developer with robust DBA skills and a strong background in the banking and healthcare sectors. My expertise includes Microsoft Azure, ETL processes, and data solution design, enabling me to implement data strategies that drive measurable business outcomes. I have a proven track record of delivering high-quality database solutions that optimize performance and enhance data accessibility. My experience encompasses Microsoft SQL Server versions 2016, 2017, and 2019, along with four years of hands-on work with Microsoft Azure, including Synapse Analytics, Dedicated SQL Pools, and Data Factory. I excel in collaborating with cross-functional teams to tailor solutions to meet diverse stakeholder needs. My commitment to continuous learning keeps me at the forefront of technology trends, ensuring I contribute innovative solutions to my organization. I possess exceptional communication and interpersonal skills, which facilitate effective teamwork and collaboration. Core Competencies MSSQL Server Administration & Development Azure Cloud Solutions (IaaS, PaaS, SaaS) ETL Processes & Data Warehousing High Availability & Disaster Recovery Solutions Performance Tuning & Optimization Excellent Problem Solving & Analytical Skills Migration other databases (Oracle) into SQL Server. Database Administrator: - Database Administration: Proficient in managing administrative tasks, monitoring databases, diagnosing issues, and implementing effective resolutions. Customer Collaboration: Engaged with clients to understand problem statements and use cases, translating them into actionable technical requirements. SQL Server Upgrades: Extensive experience in upgrading SQL Server from lower versions to higher versions, ensuring seamless transitions. Database Management: Managed a large 38TB database, developing and executing an effective maintenance plan for optimal performance. T-SQL Expertise: Skilled in writing T-SQL, including stored procedures, triggers, and functions to meet complex business needs. Demonstrated expertise in migrating databases from Oracle to SQL Server, encompassing the complete transfer of schemas, views, and necessary script rewrites. Skilled in synchronizing database objects and mapping tables to ensure seamless integration and functionality in the new environment. Cloud Solutions: Proficient in designing cloud and hybrid solutions on Microsoft Azure, focusing on network infrastructure, storage, business continuity, monitoring, and security. RDBMS Design: Experienced in RDBMS design, performance tuning, optimization, and backup/recovery across SQL Azure and various SQL Server versions (2008 2019). ETL and Reporting: Skilled in SSIS, SSRS, and SSAS technologies for data integration and reporting solutions. High Availability & Disaster Recovery: Expertise in HA and DR solutions, including Always On, mirroring, and log shipping. Data Security: Experienced in implementing Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) for sensitive data protection (DOB, SSN, Phone, Name and Custom string). Replication Configuration: Configured log shipping and various types of replications (transactional, snapshot, merge) in SQL Server environments. Standards Development: Developed, tested, and deployed database standards and processes across multiple environments. Documentation: Maintained thorough documentation of SQL Server issues and implemented effective solutions. Data Integrity Checks: Conducted database consistency checks using DBCC and DMVs to ensure data integrity. Partitioning Knowledge: In-depth knowledge of logical table partitioning from SQL Server 2005 onwards. Virtualization Proficiency: Strong understanding of VMware and virtual server configurations tailored for SQL Servers. Data Engineer: - Deployment Strategy: Expert in identifying the appropriate Azure SQL Server deployment options, purchasing models, and service tiers based on specific requirements, with the capability to execute deployments in the cloud. Azure Synapse Analytics: Proficient in deploying Azure Synapse Analytics (formerly Azure SQL Data Warehouse) within the Azure Cloud environment. Data Migration: Skilled in analyzing on-premises data warehouses and migrating data to Azure Data Warehouse, employing best practices for smooth transitions. Massive Parallel Processing (MPP): Well-versed in Azure s MPP architecture to optimize data processing and analytics. Data Modeling: Experienced in designing data models and database schemas for effective data warehousing and analytics. Migration Methodologies: Familiar with various data migration methods and best practices to ensure successful cloud transitions. PolyBase Configuration: Configured PolyBase to access external files in SQL Server, facilitating data integration. Disaster Recovery: Implemented robust disaster recovery and backup strategies to ensure data availability and business continuity. Infrastructure as a Service (IaaS): Proficient in provisioning Azure Databases in Virtual Machines, ensuring tailored infrastructure solutions. Elastic Pool Management: Experienced in deploying Elastic Pool Databases, with the ability to add or remove databases as needed. Managed Instances: Skilled in deploying and configuring Managed Instance Databases, ensuring seamless connections with SQL Server Management Studio. Serverless SQL Pools: Developed table structures using serverless SQL pools to replicate data from Oracle data sources. Service Management: Extensive experience with both managed and unmanaged services in Azure. Resource Group Maintenance: Competent in maintaining resource groups to optimize resource management and cost efficiency. PaaS Solutions: Proficient in designing and implementing applications using PaaS services in hybrid Azure environments. Storage and Data Distribution: Experienced in data distribution strategies (hash, round-robin, replicate) and configuring partitioning and distribution keys using columnstore, heap, and clustered B-tree indexes. Data Analysis Pre-Migration: Analyzed data distribution prior to migration to Azure, ensuring effective data handling. High Availability Configuration: Configured high availability solutions for managed instances to enhance operational resilience. Professional Experience Discover Financial Services, SLC , Utah May 2022 Till Date Project Experience Recovery DM (Debt Manager) Developed and supported the DFS Banking Recovery Management System, which facilitates the daily activities of business users. Enabled users to manage charge-off accounts effectively, assigning them to third-party vendors for collections and recalling accounts post-recovery. Implemented features for account removal from DM9 and the generation of comprehensive reports, enhancing collection efforts and improving agent productivity while ensuring compliance. OTIS-Lending (Student Loans) Led the migration of Discover Lending's legacy systems into the Debt Manager platform, significantly enhancing functionality to better serve customer and business needs. Developed a robust data warehouse to streamline the migration of legacy data into the new system, ensuring data integrity and accessibility. Server Upgrade Project Managed the migration of Windows and Linux database servers for Debt Manager that had reached end-of-life, transitioning to new servers equipped with updated hardware. Oversaw the entire upgrade process, ensuring minimal disruption and improved performance of the Debt Manager system. Responsibilities and Achievements Data Warehousing & ETL: Provided expertise in Data Warehousing ETL processes, including data cleansing, merging, and maintenance tasks. Database Backup Management: Created and maintained secure database backups for all critical SQL databases to ensure data integrity and recovery. SQL Server Upgrades: Led the successful upgrade of SQL Server from 2016 to 2019 and 2022, optimizing performance and features. Performance Tuning: Conducted tuning and optimization of T-SQL and stored procedures to enhance system efficiency. Installation & Configuration: Installed and configured SQL Server 2014, 2016, 2017, 2019, and 2022 in both Standard and Enterprise editions. Data Restoration: Managed the restoration of backups from production databases while ensuring sensitive data was properly handled. Consistency Checks: Performed database consistency checks using DBCC and DMVs to maintain data integrity. High Availability Solutions: Configured SQL Server 2016 Availability Groups in multi-subnet environments for improved reliability. Security Management: Applied SQL Server service packs and security patches periodically to maintain system security. Documentation: Articulated and documented ETL strategies, OLAP strategies, database sizing, security implementations, testing strategies, and deployment strategies. Database Design: Oversaw database design and implementation, directing information delivery and access for the data warehouse. Business Drivers: Identified and classified key business drivers for the data warehouse to align with organizational goals. Replication Configuration: Configured and troubleshot replication, including single, elastic, and managed instances based on requirements. Cloud Migration Support: Assisted developers in migrating on-premises databases to the cloud, ensuring a smooth transition. Auditing & Compliance: Implemented auditing measures to track database events, analyze activities, and identify potential security threats. Dedicated SQL Pools: Created dedicated SQL pools for individual applications, optimizing resource allocation. Data Loading: Utilized SSIS, PolyBase, and Azure Data Factory for efficient data loading and integration. Pipeline Creation: Developed pipelines for various data sources to streamline data movement. Security Features: Assisted in configuring Transparent Data Encryption (TDE) and data masking to protect sensitive information. Cost Management: Advised on cost optimization strategies and resource management, including deletion of unnecessary resources to save costs. Resource Support: Provided resource health support, troubleshooting, and maintenance to ensure optimal database performance. Designation: Lead database administrator Environment: SQL Server 2022, 2019, 2016, 2012, 2008, SSIS, SSRS. Capgemini, Chicago, IL Dec 2014 may2022 Data Security: Experienced in implementing Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) for sensitive data protection (DOB, SSN, Phone, Name and Custom string). Replication Configuration: Configured log shipping and various types of replications (transactional, snapshot, merge) in SQL Server environments. Standards Development: Developed, tested, and deployed database standards and processes across multiple environments. Documentation: Maintained thorough documentation of SQL Server issues and implemented effective solutions. Data Integrity Checks: Conducted database consistency checks using DBCC and DMVs to ensure data integrity. Partitioning Knowledge: In-depth knowledge of logical table partitioning from SQL Server 2005 onwards. Virtualization Proficiency: Strong understanding of VMware and virtual server configurations tailored for SQL Wipro Technologies (A, B, C, D and E) A. Capital One Financial Corporation Oct2013 Dec2014 Senior Database Administrator Contributed to one of the largest bank holding companies in the U.S., specializing in credit cards, home loans, auto loans, and savings products. Played a key role in supporting the database needs of a company with 963 branches and 2,000 ATMs, recognized as a member of the Fortune 500. Assisted in the pioneering efforts of mass credit card marketing, enhancing the customer experience through improved database management and analytics. Collaborated with cross-functional teams to optimize database performance, ensuring data integrity and availability for business operations in the U.S., Canada, and the U.K. Responsibilities and Achievements SQL Server Administration: Installed, administered, and maintained SQL Server instances to ensure optimal performance and reliability. Backup and Recovery: Planned and implemented comprehensive backup and recovery strategies for Oracle databases, safeguarding critical data. Database Security: Developed and enforced security measures for all Oracle databases, ensuring compliance with industry standards and protecting sensitive information. Migration Projects: Led the migration of SQL Server databases to Oracle using SQL Developer, streamlining processes and enhancing system capabilities. Environment Setup: Established and configured test, development, staging, and production environments to support various application needs. Database Design: Managed database design and implementation, ensuring alignment with business requirements and performance goals. User Management: Created user accounts and assigned permissions based on access levels, maintaining security and efficiency in database operations. Performance Tuning: Conducted database and application tuning and performance monitoring to optimize resource usage and response times. Capacity Planning: Planned for growth and changes through effective capacity planning, ensuring scalability and sustainability of database solutions. Technical Support: Provided 24/7 technical support as part of a collaborative team, troubleshooting issues and consulting with development teams to resolve challenges. Environment: SQL Server 2005, 2008 and Clustering B. RWE DATACENTER-TRANSITION Feb2011 Oct2013 Senior Database Administrator Contributed to one of Europe s leading electricity and gas companies, supporting operations across the entire energy value chain, including production, generation, trading, and distribution. Engaged in database management for a company serving over 16 million electricity customers and nearly 8 million gas customers, ensuring data integrity and accessibility. Collaborated with cross-functional teams to optimize database performance and support critical business functions in a dynamic energy sector. Responsibilities and Achievements Project Planning: Conducted Pre KAP and KAP studies, effectively planning and tracking the transition plans to ensure smooth project execution. Scope Preparation: Developed and articulated the project scope to align stakeholder expectations and project objectives. Documentation: Documented key strategies, including ETL, OLAP, database sizing, security implementation, testing strategies, and deployment methodologies. Data Warehouse Development: Engaged in all phases of the data warehouse development lifecycle, from requirement gathering to testing, implementation, and ongoing support. Infrastructure Setup: Established offshore infrastructure and ensured seamless connectivity to support global operations. Collaboration: Worked closely with developers and systems support personnel to enhance and automate successful code deployments to production environments. Testing and Validation: Conducted thorough testing of database access from offshore locations to ensure reliability and performance. Customer Relationship Management: Maintained strong customer relationships and provided 24/7 service management, addressing client needs promptly. Process Definition: Defined and implemented processes and SLAs, ensuring adherence to operational standards and expectations. Technical Review: Reviewed technical and process documents related to the transition, ensuring all requirements were met and potential issues were identified. Environment: SQL Server 2005, 2008 and Clustering Client location: UK C. CAP-CCP Reporting Operations at Microsoft Feb2011 Oct2012 Database Administrator Managed a high-visibility data warehouse project supporting large databases with terabytes of data, enabling critical analysis of call center workflows and various analytical studies. Delivered comprehensive reporting solutions that informed daily operations and decision-making for business users, including director-level stakeholders at Microsoft. Maintained an impressive track record of meeting nearly 100% SLA metrics daily, ensuring operational excellence and zero downtime. Oversaw a fully integrated environment utilizing SSIS, SSRS, SSAS, and SQL Server 2008, optimizing data processing and reporting capabilities. Collaborated closely with cross-functional teams to troubleshoot issues and enhance system performance, contributing to overall project success. Responsibilities and Achievements SLA Management: Oversaw SLA activities for a large data warehouse, ensuring compliance and timely support for all operational needs. Executive Support: Provided executive-level support for the data warehouse project, aligning technical initiatives with business objectives. Business Analysis: Identified and classified key business drivers, enhancing the relevance and impact of the data warehouse solutions. Server Maintenance: Managed approximately 200 servers across various environments, including Production, PPE, UAT, and Test, ensuring optimal performance and availability. Technology Implementation: Implemented SSIS and SSRS technologies tailored to meet specific business requirements, improving data integration and reporting capabilities. Database Optimization: Enhanced database design for improved query performance through logical table partitioning, indexed views, and indexing strategies. ETL Processes: Developed and maintained ETL jobs to facilitate efficient data extraction, transformation, and loading. System Updates: Applied regular service packs and cumulative updates to servers, maintaining system integrity and security. Architecture Design: Designed and implemented the data warehouse architecture for corporate circulation, establishing a standard for divisional data warehouses and enabling the creation of data marts and reports based on conformed facts and dimensions. Server Upgrades: Executed server upgrades and security patch applications, ensuring compliance with the latest standards. Information Delivery: Directed and designed information delivery and access strategies for the data warehouse, enhancing user experience and data usability. Security Management: Managed password change activities in SSRS, SSAS, and SQL Server to uphold security protocols. Release Management: Coordinated quarterly releases and system enhancements, planning and recommending improvements to the operational environment. Environment: SQL Server 2005, 2008, SSIS, SSRS and Windows Cluster Reporting: Jon Brown Client location: USA Client: Microsoft D. Fosters Group AUG 2009 FEB 2011 Foster's operates three regional businesses across Australia, Asia & Pacific (AAP), and Americas, Europe, Middle East, and Africa (EMEA), focusing on delivering a diverse portfolio of beverages, including beer, wine, spirits, ready-to-drink options, cider, and non-alcohol brands. With a commitment to sustainable growth, Foster's emphasizes continuous improvement and innovation, aiming to achieve strong financial returns. The company employs over 10,000 people globally and maintains a presence in key markets, including the UK, Europe, the US, Australia, New Zealand, and Asia, with products available in more than 150 countries. As the leading alcohol company in Australia and the Asia Pacific region, Foster's is renowned for its flagship brands, including the world-famous Foster's Lager. Key Responsibilities and Achievements Production Database Management: Played a critical role in managing production database servers, particularly during peak periods, ensuring optimal performance and uptime. Issue Resolution: Addressed all database-related issues in production environments, maintaining high operational standards. Database Maintenance: Conducted regular maintenance activities, including backup monitoring, database health checks, daily job monitoring, and re-indexing. High Availability Solutions: Installed and maintained high availability solutions, including: Log Shipping Mirroring Failover Clustering Replication Project Execution: Managed project-related tasks, such as executing DTS and SSIS packages, scripting stored procedures, and installing SQL Server versions (2000/2005/2008). Regular Maintenance: Carried out weekly and monthly maintenance tasks, including patching and installing service packs. Database Recovery: Handled critical issues like T-log full errors, disk space problems, database suspect states, and performed point-in-time recovery for corrupt databases. Operating System Tasks: Managed OS-related tasks, including rebooting servers, analyzing performance, scheduling Windows tasks, and troubleshooting using performance counters and the Event Viewer. Performance Monitoring: Utilized tools like Idera, SQL Profiler, and performance counters to monitor database performance effectively. Service Improvement Initiatives: Implemented service improvement plans, including preparing monitoring scripts and disk space alert systems. Reporting: Directly reported to the Project Manager. Designation: Database Administrator Environment: SQL Server 2005, 2008 2008 R2 and Clustering E. Microsoft Dec 2007-AUG 2009 Key Responsibilities and Achievements: End-to-End Production Support: Provided comprehensive database production support, ensuring high availability and performance in a 24/7 operational environment. SQL Job Management: Demonstrated extensive experience in creating, executing, and troubleshooting SQL Jobs on SQL Server 2000 and 2005. Cluster Installation: Installed MS SQL Server in a clustered environment and configured Windows clustering to enhance system reliability. Data Replication: Established replication between different environments, ensuring data consistency and availability across systems. Disk Space Management: Managed disk space effectively, ensuring optimal storage utilization and performance. Index Management: Created and managed standard and partitioned indexes to optimize query performance. Database Mirroring: Configured database mirroring with a witness server for enhanced availability. DTS Package Development: Developed and executed DTS packages for transferring jobs and logins from SQL Server 2000 to 2005. SSIS and VBScript Execution: Executed SSIS packages and VBScript scripts on SQL servers for data integration and automation tasks. Hardware Proposals: Provided proposals for server and hardware RAID configurations to enhance enterprise solutions. Database Maintenance Plans: Implemented comprehensive database maintenance plans, focusing on security management and clustering. Log Shipping Configuration: Configured log shipping to ensure data redundancy and disaster recovery capabilities. Collaboration and Coordination: Coordinated with the application team through migration review meetings and post-migration QA and support. Capacity Planning: Conducted server and storage resource capacity planning and allocation to meet future growth and performance requirements. Ticket Resolution: Efficiently resolved support tickets based on priority, ensuring timely responses to critical issues. Designation: Database Administrator Environment: SQL Server 2000 and 2005 Project: MBSIT Platform Support (24/7) ________________________________________ Keywords: cprogramm quality analyst access management microsoft Illinois