| Vikas - Database Administrator/ Site Reliability Engineer/Developer - 14+ years Exp - H1b - Current Location : Portland, OR - Willing to relocation anywhere in USA at Portland, Oregon, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1379161&uid= CEIPAL ATS - Simplified Recruiting and Staffing Vikas - Database Administrator/ Site Reliability Engineer/Developer - 14+ years Exp - H1b - Current Location : Portland, OR - Willing to relocation anywhere in USA Consultant's Details: Consultant Name: Vikas Location: Portland,OR (Willing to Relocate anywhere within the USA) Employer Details: Employer:Nextgen Technologies Inc Contact Person:Kushal Email:[email protected] Note: Please call between 09:30 AM PST to 06:00 PM PST Phone: +1 (413) 424-0484 Vikas's Resume Database Administrator/ Site Reliability Engineer/Developer SUMMARY: Experienced Database Administrator with over 14 years of expertise in database administration and development, specializing in SQL Server and cloud technologies along with Site Reliability Engineer. Proven track record in Agile methodologies, DevOps practices, and managing large-scale Azure and AWS cloud environments. 5 + years of experience in Microsoft handling 4500 servers and Azure infrastructure. performance tuning & optimizing SQL queries. 12 + years experience in various cloud environments Azure & Aws (PAAS & IAAS) Build and manage RDS PostgreSQL, Azure Databases, Build VMs, Azure Data Factory, MySQL, and MSSQL, Sybase. Excellent Experience in MS SQL Server installation, building Cluster & Geo Cluster Servers along with configuring, performance Tuning, Query Optimization, Upgrade, Backup/Recovery, and Managing Security. Excellent knowledge of SQL Server Replication, Log Shipping, Mirroring (HADR), and SQL Server 2012/2014/2016/2017/2019/2022. Experienced in Power BI Report, SSIS/SSRS/SSAS, PostgreSQL, RDS Amazon Web Services, Windows Azure, and Databases & MYSQL Databases. Designed, maintained, and documented a highly transactional OLTP system scaling up to 10 million transactions. Experienced in handling End to End end-project management Activities which include Planning, Design, Scope Management, Estimation, Resource Administration, and completion of projects within specified Timeframes and Parameters TECHNICAL SKILLS: Databases: SQL Server (2000-2022), PostgreSQL, RDS on Amazon Web Services, MySQL, Oracle Cloud Technologies: Azure (Azure Data Factory, Azure Data Lake, Azure SQL), AWS Programming Languages: T-SQL, Power, VBScript Tools & Utilities: SSIS, SSRS, SSAS, SCOM, Power, ER Studio, Visio Operating Systems: Windows Server, UNIX, Linux Other: Agile Methodologies, DevOps Practices, Site Reliability Engineering Professional Experience: Quiktrak Inc. (March 2020 - Present) Lead Database Administrator & SQL Developer Led a Team of 4 Database Administrators and mentoring junior team members, conducting performance evaluations, and collaborating with cross-functional teams to ensure seamless integration of database solutions with business processes. Involved in Planning, researching, Architect the environment for Servers and Databases with different stakeholders and teams. Implemented projects for Migration, Performance tuning, DR setup, Backup Policies, and Implementation, of Security and High Availability Solutions to the database and Servers. Architecture and migrated database to a complex and critical Microsoft SQL Server environment from 2016/2017/2019 to SQL SERER 2022 on Azure and implemented disaster recovery solutions by building Active/Active & Active /Passive Clusters and using Always on for SQL Server databases. Spearheaded the administration of Microsoft SQL Server databases, ensuring optimal performance, high availability, and disaster recovery solutions. Migrated SQL Server instances to Managed instances on Azure and to Azure SQL Databases. Migrated on-premises SQL databases to Azure SQL Database using tools like Azure Database Migration Service. Having a complex environment for Replication data to fulfill the need of Reporting purposes and for DataMart. Migrated ETL packages from on-premises to Azure data factory. Working closely with business users to understand the clients requirements and develop (SSIS) ETL packages and SSRS reports per their requirements (for clients like BOFA, US bank, Huntington, and many more). Implemented Backup strategies and optimized SQL queries. Developed several database structures, complex SQL queries, writing stored procedures, Views, Triggers, and User-defined functions. Performed automating and standardizing of the production environment using Power, TSQL, SSRS, etc. Identifying Running Queries T-SQL & analyzing and optimizing them and automating the processes. Upgraded & executed MYSQL migration from 5.7 to 8 version. Configuring Master/Slave replication and implementing a backup strategy for production servers. Administrating and Installing MYSQL databases , on-premises/AWS configuring replication, and optimizing SQL queries, using Workbench. Manage and build configuration of PostgreSQL Server (9.8 & 8.0) on-premises and AWS RDS instances. Maintaining PostgreSQL Linux servers and monitoring the health and uptime of the databases. Migrated on-premises PostgreSQL environment to AWS RDS instance. Administered PostgreSQL databases using pg_Admin and Psql. Upgraded database versions using pg_dump/pg_restore and pg_upgrade tools and I made sure the latest security patches to the database were updated, the PostgreSQL open-source community provides this. Performed Backups (pg_basebackup, pg_backrest, pg_dump) and restored operations, compressed backups, and database/schema refreshes. Experienced on restore operations (pg_restore) and Point in Time Recovery Used pg_Bouncer for connection pooling, pg_Badge for generating statistic reports. Tools Used: SSMA, The Data Migration Assistant (DMA) Azure Services. Senior MSSQL Database Administrator/Developer Orion Systems Integrators LLC (October 2019 - March 2020) Project: Universal Store (Microsoft Corp.) Orchestrated the migration of databases from SQL Server 2008 to SQL Server 2012/2014/2016/20172019, including cloud-based deployments on Windows Azure. Built and managed SQL Server infrastructure on Azure, including clusters and Always On configurations. Responsible for building new infrastructure for EOL and Migration database of 2008 to SQL 2012/ SQL 2014/ SQL 2016/SQL2017 Servers and Cloud databases (Windows Azure). Developed several database structures, complex SQL queries, writing stored procedures, Views, Triggers, and User-defined functions. Identifying Slow Running Queries T-SQL & analyze and optimizing them. Developed and rendered monthly, weekly, and daily reports as per the requirement and gave roles, and user access to security in Report Manager. Configure Transactional Replication for the reporting purposes. Development, implementation, and maintenance of OLAP cubes and ETL packages. Development of SSRS reports and SSIS package. Development of Key Performance Indicators (KPIs), Dashboards, Scorecards, drill-down reports and linked reports for senior executives and marketplace managers required for business performance and forecasting and used BI reporting. Create and maintain Power BI reports and dashboard. Building and managing geo-cluster, Active-Active, Active Passive Clusters Developed SSRS reports and Power BI dashboards for business intelligence and analytics. Implemented OLAP cubes and ETL packages for data integration and reporting. Enom Inc. (Formerly RightSide) (December 2015 - October 2019) MSSQL/MYSQL/PostgreSQL Database Administrator/Developer Managed highly complex cross-datacenter SQL clusters, including migrations and high-availability solutions. Technical support services consisting of Tier 3 level System Administration across multiple areas of subject matter expertise for Microsoft Corp. Managed 100+ Production/QA+Dev servers with multiple databases, with couples of them over 10-12 terabytes both in a Cluster environment with Mirroring and Replication and Implemented Always On. Responsible for building new infrastructure for EOL and Migration database of 2008 to SQL 2012 & SQL 2014 Servers and Cloud databases (Windows Azure). Managed Query Optimization and Performance Tuning of Stored Procedures, Functions, etc. Developed Power BI reports and SSIS packages for data visualization and ETL processes. Implemented SOX/PCI-compliant databases and automated production environment using Power and T-SQL. Implementing Service Pack upgrades on SQL Servers for QA/Dev and Production Database. Green Infosystems LLC -- Redmond, Washington, US August 2013-To December 2015 Sr. MSSQL Database Administrator Project Name: Learning-MSCom (Microsoft Corp.) Microsoft vendor Technical support services consisting of Tier 3 level System Administration across multiple areas of subject matter expertise for Microsoft Corp. Managed 100+ Production/QA+Dev servers with multiple databases, with couples of them over 10-12 terabytes both in a Cluster environment with Mirroring and Replication and Implemented Always On. Responsible for building new infrastructure for EOL and Migration database of 2008 to SQL 2012 & SQL 2014 Servers and Cloud databases (Windows Azure). Working knowledge of Azure VMs, Azure Virtual Network, Service Bus, Azure Storage, X.509 certificate in Microsoft Azure. Developed ETL Solutions for various teams. Recommendation/Configuring of availability strategies database mirroring, clustering, and setting up a database for replication, log shipping, and Database mirroring and monitoring the setup & Creating SSRS reports. Scheduled Backups of databases and recovered them periodically to verify the integrity of Backups. Experience working with Lite Speed. Developed several database structures , and complex SQL queries, writing stored procedures, views, triggers, and user-defined functions. Identifying Slow Running queries by the profiler, T-SQL & analyzing and optimizing them. Managed Query Optimization and Performance Tuning of Stored Procedures, Functions, etc. Performed Code Reviews and developed Coding Standards considering SQL Server Best practices. HCL America Inc. -- Redmond, Washington, US Feb 2010 August 2013 Sr. MSSQL Database Administrator Project Name: Bing-AdCenter (Microsoft Corp.) Microsoft vendor Managed a geographically distributed Application Support Team providing services for Deployment, Incident, and Infrastructure Mgt. for a portfolio of Microsoft business applications and services. Onsite-offshore coordination designed processes for effective communication with offshore teams. Responsible for handling the Production environment of the BING ADDS, Microsoft Corp having Databases in 8-10 TBs. and 45000 Severs. Maintaining Site and Database performance, uptime of 99.99. Migrated SQL Server 2008 Clusters to Always on Failover Cluster Instances in SQL Server 2012. Developed ETL Packages and provided data to the various teams based on their business model. Responsible for query optimization using SQL tools such as SSMS, SQL Profiler, and Index tuning wizard. Worked on incident management issues as per IMR/Tickets raised by the UTS monitoring system. Working closely with various teams at client locations to gather and understand the database requirement setting up of new MSSQL Server 2008 and 2012 databases in both development and production environments and coordinating with the clients for enhancements. Attend weekly production support status meetings with Clients and address the gaps, if any. Performing the root cause analysis of production issues and ensuring monitoring automation of the MS-SQL Server. Implemented and Maintained Disaster Recovery for Production Database Environment Recommendation/Configuring availability strategies Database Mirroring (Always on), Clustering and Setting Up database for Replication, Log Shipping, and monitoring the setup. Education & Certifications: Masters in computer applications (MCA) from IGNOU, 2005 Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions Administering Microsoft SQL Server 2012, 2016/2019/2022 Databases Bachelors in arts from Delhi University, 1997 Certification in Computing (CIC) from IGNOU Post-Graduation Diploma in Computer Application (PGDCA) from IGNOU Note: Please call between 09:30 AM PST to 06:00 PM PST Kushal | 1735 N 1St ST., Suite 102 |San Jose, CA 95112 NextGen Technologies Inc Email: [email protected]. Website: www.nextgentechinc.com | +1 (413) 424-0484 | Keywords: quality analyst access management business intelligence microsoft California Vikas - Database Administrator/ Site Reliability Engineer/Developer - 14+ years Exp - H1b - Current Location : Portland, OR - Willing to relocation anywhere in USA [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1379161&uid= |
| [email protected] View All |
| 12:43 AM 09-May-24 |
| Attached File(s): Vikas Behl_Resume_1715195596756.docx Please check the file(s) for viruses. Files are checked manually and then made available for download. |