| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEContact No PHONE NUMBER AVAILABLEObjectiveTo be part of a progressive organization that allows me to leverage my knowledge and skills in Information Technology, while pursuing challenging opportunities that foster both personal and professional growth.Profile SummeryAs an experienced MSSQL Server Developer with strong DBA expertise, I offer a unique combination of technical skills and industry knowledge, particularly in the banking and healthcare sectors. My proficiency in Microsoft Azure, ETL processes, and Azure development allows me to design and implement efficient data solutions that drive business outcomes.I have a proven track record of delivering high-quality database solutions that optimize performance and enhance data accessibility. My understanding of industry-specific business processes enables me to tailor solutions that meet stakeholders' unique needs. Additionally, I possess excellent communication and interpersonal skills, facilitating effective collaboration with cross-functional teams.My enthusiasm for technology and commitment to continuous learning ensure that I remain at the forefront of industry trends, contributing to innovative and effective solutions. I have thorough knowledge of Microsoft SQL Server 2016, 2017, and 2019 on Windows operating systems, and I bring four years of experience with Microsoft Azure, including Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, Data Lake Gen1, and Data Factory.Database Administrator: -Experienced in handling administrative tasks, database monitoring, diagnosing, and resolving database issues efficiently.Collaborated with customers to understand problem statements and use cases, translating them into tangible technical requirements.Excellent experience in Upgrading SQL Server lower versions to higher versionsManaged a large 38TB single database, developing and implementing an effective maintenance planExpertise in T-SQL, including writing stored procedures, triggers, and functions.Proficient in designing cloud and hybrid solutions on Microsoft Azure, covering network infrastructure, storage, business continuity, monitoring, and security.Experienced in RDBMS database design, performance tuning, optimization, and backup and recovery across SQL Azure, SQL Server 2008/2012/2014/2016, and 2019.Skilled in SSIS, SSRS, and SSAS technologies.Expertise in high availability (HA) and disaster recovery (DR) solutions, including Always On, mirroring, and log shipping.Experienced in Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) for sensitive data within SQL Server.Configured log shipping in SQL Server 2008 R2, 2012, and 2014.Configured transactional, snapshot, and merge replication.Developed, tested, and deployed database standards, processes, and procedures across various environments.Documented SQL Server issues and implemented necessary solutions.Expertise in Reporting Services with a basic understanding of Analysis Services.Conducted database consistency checks using DBCC and DMVs.Excellent knowledge of logical table partitioning from SQL Server 2005 onwards.Strong understanding of VMware and virtual server configuration for SQL Servers.Data Engineer: -Identify right Azure SQL Server deployment option, purchasing model and service tier according to requirements and will be able to deploy it in cloudDeploy Azure Synapse Analytics (formerly known as Azure SQL Data warehouse) in Azure Cloud environmentAnalyze on-premises data warehouse and migrate data to Azure Data Warehouse.Well experienced in Azure famous MPP (Massive Parallel Processing) architectureDesigning data models and database schemas for data warehousing and data analytics purposesExperienced in different migration methods and best practicesConfigure Polybasic to access external files into SQL Server.Implementing disaster recovery and backup strategies to ensure data availability and business continuityProvision Azure Database in Virtual Machine (IaaS)Deploy Elastic Pool Database and able to add/remove more databases from the poolDeploy the Managed Instance Database, configure it and connect with your SQL Server Management studioServer-less SQL pools to develop table structures to replicate data from an Oracle data sourceExperienced in managed and unmanaged services.Well experience in Resource group maintenance.Experience in designing and implementing applications using PaaS Services in a hybrid Azure environmentWell experience in IaaS (Infrastructure), PaaS (Platform) and SaaS (Software as a Service)Experience in Storge & Data Distribution (Hash, Round-robin, Replicate)Experience in Partitioning and Distribution key using Colum store, Heap, Cluster B-tree indexAnalyzing data distribution before migration to AzureConfigure High availability in managed instanceProfessional ExperienceDiscover Financial Services, SLC March 2014 Till DateRecovery DM (Debt Manager) supports the daily activities of business users within the DFS Banking Recovery Management System. Users leverage the DM tool to manage charge-off accounts, assign them to appropriate third-party vendors for collections, and recall accounts once they are recovered. The system also enables the removal of accounts from DM9 and the generation of comprehensive reports. DM9 enhances collection efforts, improves agent productivity, and ensures compliance.OTIS-Lending (Student Loans) involves the migration of Discover Lending's legacy systems into the Debt Manager platform, providing enhanced functionality to better meet customer and business needs. A data warehouse has been developed to facilitate the migration of legacy data into the new system.Additionally, the Server Upgrade Project encompasses the migration of database Windows and Linux servers for Debt Manager that have reached their end of life. This includes transitioning to new servers built with updated hardware.Provided expertise in Data Warehousing ETL, data cleansing, merging data, maintenance taskCreate and maintain secure database backups for all critical SQL databasesImplementation of SQL Server Upgrade from 2016 to 2019 and 2022Tuning and Optimization of Transact SQL, Stored ProceduresInstallation and configuration of SQL 2014, 2016, 2017, 2019 and 2022 Standard and EnterpriseRestoring backups from production databases after removing sensitive dataDatabase consistency checks using DBCC and DMVsConfiguring SQL 2016 Availability groups in multi subnets.Appling SQL Server SPs & security patching periodically.Articulate and document: ETL Strategy, OLAP Strategy, Database Sizing, Security implementation, Test Strategy, and deployment strategy.Take care of the Database design and implementationDirect and design the information delivery and access for the data warehouse.Classified key business drivers for the data warehouse.Configure Replication and troubleshootingCreating Single, Elastic, and managed instance as per requirement.Help developers to Migrate databases on- premises to cloudUsing Auditing to track database events to analyze investigate database activities to identify potential threatsCreate Dedicated SQL Pool for individual application.Loading data with SSIS, PolyBase and data FactoryCreate Pipelines in different data source for moving data efficiently.Help Transparent data encryption data masking configuration.Help them about managing cost and price optimizationResource health, support, and troubleshootingDelete unwanted resource and save costTake care of the Database design and implementationDirect and design the information delivery and access for the data warehouse.Classified key business drivers for the data warehouse.Configure Replication and troubleshootingConfigure mirroring and troubleshootingConfigure Tags as per requirementConfigure mirroring and troubleshootingDesignation: Lead database administratorEnvironment: SQL Server 2022, 2019, 2016, 2012, 2008, SSIS, SSRS.Wipro Technologies (A, B, C, D and E)A.Capital One Financial Corporation Oct2013 Dec2014Capital One Financial Corporation is a U.S.-based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. In terms of total assets and deposits, Capital One is the eighth largest bank holding company in the United States. As of 2012, the bank has 963 Capital One Bank Branches including 10 caf style locations for their Capital One 360 brand and 2,000 ATMs. Capital One Financial is a member of the Fortune 500, and conducts business in Canada and the United Kingdom. The company helped pioneer the mass marketing of credit cards in the 1990s, and it is now the fourth-largest customer of the United States Postal Service.Installation, Administration and Maintenance of SQL Server InstancesPlans and implements backup and recovery of the Oracle databaseImplements and enforces security for all of the Oracle DatabasesMigrating SQL Server to Oracle Database Using SQL DeveloperSetup Test, Dev, Staging and Production EnvironmentsTake care of the Database design and implementationCreate Users and assign permissions based on the level of database access the user would needDatabase tuning and performance monitoringApplication tuning and performance monitoringPlan growth and changes (capacity planning)Work as part of a team and provide 7 24 supports when requiredDo general technical trouble shooting and give consultation to development teamsDesignation: Senior Database AdministratorEnvironment: SQL Server 2005, 2008 and ClusteringB.RWE DATACENTER-TRANSITION Feb2011 Oct2013RWE is one of Europes five leading electricity and gas companies. Through our expertise in oil, gas and lignite production; electricity generation from gas, coal, nuclear and renewable; energy trading as well as electricity and gas distribution and sales; we are active at all stages of the energy value chain. Around 70,000 employees supply over 16 million electricity customers and nearly eight million gas customers.Pre KAP and KAP studyPlan and track the transition planPrepare the Project ScopeArticulate and document: ETL Strategy, OLAP Strategy, Database Sizing, Security implementation, Test Strategy and deployment strategy.Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.Setting up of offshore infrastructure and connectivity.Work with developers and systems support personnel in elevating and automating successful code to productionTesting of the access of databases from OffshoreCustomer relationship management and 24x7 Service Management.Process and SLA definition and implementationReview of technical and process documents of transitionDesignation: Senior Database AdministratorEnvironment: SQL Server 2005, 2008 and ClusteringClient location: UKC.CAP-CCP Reporting Operations at Microsoft Feb2011 Oct2012CAP and CCF Operations is a data warehouse environment project where we support huge databases with terabytes of data. Its a critical warehouse data environment as it helps business to analyses their call center business workflow and various analytical element studies. Based on the reports we publish in the environment they do their daily activities and action items. This project has huge visibility across Microsoft comprising of director level people. Its very important to have all the SLA met.We have almost 100% SLA met metrics on daily basis so far with no operational failures. The environment is a complete integration on SSIS, SSRS, SSAS and SQL SERVER 2008 databases.Handled SLA activities comprising of huge data warehouse data.Determined executive level support for the project of data warehouse.Classified key business drivers for the data warehouse.Maintained about 200 servers for all the environments including Production, PPE, UAT, Test etc.Implemented SSIS and SSRS technologies based on the business requirement.Modified database design to improve the performance of the Query outputs using Logical table partioning, Indexed views, Indexes etc.ETL jobsAppling regular service packs and cumulative updates on serversDesigned and implemented data warehouse architecture for the corporate circulation data warehouse that became the standard for divisional data warehouses. Subsequent data marts, extracts and reports were sourced from an architecture of conformed facts and dimensionsUpgrading servers and security patch application.Direct and design the information delivery and access for the data warehouse.Password change activities in SSRS, SSAS and SQL Server.Applying and managing Quarterly releases.Planning and suggesting the environment improvement activitiesDesignation : Database AdministratorEnvironment: SQL Server 2005, 2008, SSIS, SSRS and Windows ClusterReporting: Jon BrownClient location: USAClient: MicrosoftD.Fosters Group AUG 2009 FEB 2011Fosters has three regional businesses - Australia, Asia & Pacific (AAP), Americas, Europe, Middle East and Africa (EMEA) - with their goal to offer a portfolio of the best beer, wine, spirits, ready-to-drink, cider, and non-alcohol brands to suit every drinking occasion.As Foster's continues to build their business, their focus is on delivering strong, consistent returns on all financial measures. Foster's wants to develop the capability for sustainable growth through continuous improvement and innovation. Foster's have a team of more than 10,000 people in locations around the world. Foster's have operations in the United Kingdom, Europe, the United States, Australia, New Zealand and Asia, and their products are sold in more than 150 countries worldwide. As the leading alcohol company in Australia and the Asia Pacific, Foster's is the proud owner of the region's favorite brands and the world's most famous Australian beer; Foster's Lager.Performed key role in handling Production database server during peak timesResponsible for all database related issue in production serversDatabase Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring and Re-indexing etc.Installed, Administering and maintaining High availability solutions likea) Log shippingb) Mirroringc) Failover Clusterd) ReplicationProject related activities like executing DTS Packages, SSIS Packages, scripting SPs, installing SQL Server 2000/2005/2008Weekly/Monthly maintenance tasks like Patching, installing Service PacksDatabase related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases, point in time recovery etcOS Related tasks like Rebooting Servers, analyzing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etcDB Performance monitoring using tools like Idera, Profiler, Perf Counters,Implemented Service Improvement Plans like Preparing Monitoring Scripts, Disk space alerts script etcReporting: Project ManagerDesignation: Database AdministratorEnvironment: SQL Server 2005, 2008 2008 R2 and ClusteringE.Microsoft Dec 2007-AUG 2009Providing end to end solutions to Database production supportMember of MBSIT Platform support (24/7 project).Very good experience on SQL Jobs (Creating, Executing and troubleshooting on 2000, 2005)Installed MS SQL Server on Cluster environment and Configured windows clustering.Created Replication between two deferent environmentsPerforming Disk Space Management.Creating and Managing Indexes and Partitioned IndexesPerforming Database Mirroring configuring Witness ServerCreated DTS Packages for Transfer (Jobs, Logins MS-SQL Server2000 to MS-SQL Server2005)Executing DTS, SSIS and VBScripts on SQL servers.Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions.Implementation of database maintenance plans, database security management, and clustering.Configuring Log shippingCoordinate with Application Team through migration review meetings and post-migration QA and support.Server and storage resources capacity planning and allocation.Resolving Tickets based on priority.Designation: Database AdministratorEnvironment: SQL Server 2000 and 2005 |
