John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π personal email
- Valid
John is a Certified Database Administrator working in Microsoft Data Platform technologies, with a focus on Implementing, Migrating & Managing High Available-Enterprise scaled Database systems and HA-DR solutions in On-Prem & Azure platforms.Victories: * Successfully completed a Multi-million $$ platform-integration and marketing campaign migration project (Ahead of schedule)* Re-structured & Re-built disk subsystem Storage Pool-Optimized iOPS and for scalability. (Saving $50K annually*)* Re-Balanced\Migrated AG & AGDB to new expanded load-bal SQL Server 2016 -AG Replicas.* Implemented Encrypted VLDB 25TB AOAG & Distributed AG High Availability solution on multi Replica Azure Load Balanced Availability Set.* Migrated Mil$$ revenue generating SQL FCI from SQL Server 2008 r2 to 2014.* Implemented 5 sets Active-Active four Node SQL Cluster Group - FCI Platform on SQL Server 2014 & 2008 r2 (HA-DR)HIGHLIGHTS: ***Server/DB Expertise: in PROD, Pre-Prod & Non-Prod environments.-In On-Prem SQL Server; - most recently with 2017-2019 & in earlier versions of 2016 to 2000. HA-DR AOAG, AOFCI, Encryption-In Azure Cloud IaaS/PaaS; - Azure VM SQL Server, Azure SQL DB, Azure SQL MI, Availability Set & Zone, Active Geo-Replication, Auto-Fail over Group, Blob Storage, AZ Key Vault, Cloud Witness--Migrated core, revenue generating SQL DB (HA-DR) application running on SQL Server 2008-2014 versions, to 2017/2019- On-Prem.*Built, Optimized, Scaled Azure-SQL Server Enterprise Infrastructure. (Meet 99.99% SLA)Skills Set: SQL Server Versions: SQL Server 2019, 2017, 2016-2000HA/DR: AOAG, DAG, AOFCI/WSFC- SQL Server Cluster-FCI, Mirroring, Log Shipping, ReplicationSecurity: Database Encryption At-Rest & In-Flight | Database Obfuscation- DDM Masking | User Access Platforms: Azure IaaS/PaaS | On-Prem Data Center, VMWin OS: Windows Server 2022, 2019, 2016, 2012r2Monitoring Tools: Foglight, DataDog, iPmonitor, iDera SQL DM, SCOMCollaboration: Teams/Slack/Hangouts. Azure DevOps/Confluence/Jira/Git, SRE.SQL Life-Cycle environments: Production, Stage, UAT/QAT, INT/SIT, & Dev. DRLang/BI Space/ETL : T-SQL, MDX, Powershell | Azure Data Studio/SSDT-BI/BIDS/VS | Azure Data Factory/SSIS-IR, SSIS, SSRS, SSASPlatform Data Integration: SQL Server, Oracle, Teradata, MySQLITIL-ITSM: Agile, Sprint, Kanban, CAB/CMB | Incident & Problem Management | Root Cause Analysis & Resolution | ServiceNowJohn takes ownership of his projects & roles. Primarily works as an individual contributor and enjoys collaboration in partnership with small/large teams.
Osos-Wa
-
Osos-WaKirkland, Wa, Us
-
Database Administrator SrOsos-Wa 2022 - PresentStabilize, Secure, Scale AG HA/DR, Replicated, Encrypted On-Prem VLDB SQL Server database solution for highly sensitive citizen application systems.Build next gen SQL Database Systems in Azure, Migrate to Cloud.
-
Sql Server Consultant-Dba | Azure, Ha/Dr - Aoag; Cluster-Fci, On-Prem/Vm@Sos, Lpl, Pbc, Dfin, Fhcrc, Tmus, Msft, Thd, Goog, Jpm, Acn, Hcl, Tcs, Tek 2007 - PresentAzure IaaS/PaaS, Availability Sets, Always On, AOAG/PAG-DAG. Azure Blob Storage-SAS/KeyVault, VM Storage Spaces-Pool.Migrated On-Prem SQL Databases to Azure IaaS & PaaS 2016-2019.Implemented HA-DR on a 8 Replica LoadBal Availability Set, SQL Infra in PROD -Supports Terabyte VLDBsMigrated Availability Groups & AG DBs to new Availability Set-ReplicasBuild Azure POC SQL Server environment (Windows Server 2019/SQL Server 2019)Generate Rolling upgrade protocol & Implement for SQL Server Replicas with AOAG.Implemented a 20 Node PROD SQL Cluster on Windows Server 2012r2 -SQL Server 2014Implemented a 24 Node PROD SQL Cluster on Windows Server 2008r2 -SQL Server 2008 R2Migrated PROD SQL Database Application to 2014, 2016.-> Managed & successfully completed a Multi-million$ platform-integration and marketing campaign migration project for a financial services firm 2 months ahead of schedule-> Manage SQL Server Infrastructures hosting 1000+ Servers/10,000+ DB-> Built & successfully On-boarded a SQL Server 2014/2008 R2 Cluster based "Calculation-Delivery Platform". On-Boarding applications grew from 2 to 12 -> Build, Install, Configure & setup database systems in Azure-SQL Server 2019, 2017, 2016, 2014, 2012, 2008r2, 2005, 2000.-> Manage SQL Server databases through the various SDLC/PDLC environments, from development to production-> Configured FCI and setup Always On Availability Group -HA-DR solution.-> Delivered & maintained 99.9% server/database up-time in all 24 x 7 PROD environments-> Exceeded & met all SLA/OLA (Service & Operational Level Agreement) metrics-> On-Time delivery to Production & Audit with Zero Post-Production defects-> Implemented backup strategy and maintenance of SQL Server Clustered, On-Prem/VM & Stand-Alone.-> Implement disaster recovery/backup strategy solution (RTO-RPO)*Upgrade 2008 SSIS to 2017 SSISDW.*Migrate SSIS packages to Cloud-Azure Data Factory. For Managed Instance/Azure SQL DB | Automate Jobs & ADF Pipeline
-
Database AdministratorLpl Financial Mar 2021 - 2022San Diego, Ca, UsUpgrade-Migration Project: Engage - Collaborate - Implement - DeliverRevamp existing back-end SQL Server Database Systems & Infrastructure to latest 2017-2019.Windows OS, Infra & Applications supporting core Billion $$ revenue generating Financial & Investment-Wealth Management Systems.Continues delivery Migration Project | Kanban-Scrum | Cloud, On-Prem | HA/DR -AOAG -
Database AdministratorPremera Blue Cross 2020 - 2021Mountlake Terrace, Washington, UsSupport-Manage the core Insurance application High Available SQL Server Infra and Database systems hosted On-Prem\VM & in Azure Cloud Infra. Modernize with Migration to SQL 2019\2017.Administer, Maintain-Patch, Support, Upgrade & Operationalize Enterprise Database Systems in AOAG, SQL Cluster HA-DR solutions.#workfromhome, #remoteRPO/RTO 99.99% SLA -
Azure_Cloud Sql Server Dba - Cloudops/SreDonnelley Financial Solutions (Dfin) 2018 - 2019Chicago, Illinois, UsThe Database Administrator for it's core high transaction multi Availability-Set Azure Load-balanced & Distributed SQL Server Database Systems. Manage its AOAG HA-DR encrypted solution on multi-terabyte Cloud-Azure AD application supporting SEC fillings for publicly traded companies. -
Database AdministratorFred Hutch 2017 - 2018Seattle, Wa, UsDatabase Administrator - Cloud Fwd
Sql Infra DbaT-Mobile 2015 - 2016Bellevue, Wa, UsBuild, configure, manage & support SQL Server Infrastructure Eco-System shop for this company-(2016 / 2014 / 2012 / 2008 R2-2008 / 2005) Utilizes AOAG, Cluster-FCI/CSV, DR, APS-PDW.Secure, manage database, business applications in Pre-PROD (Version, Code)- Ensure smooth migration & streamline CR/Build deployments from QAT/UAT to PROD.Built audit reports using SSRS to certify internal compliant with SOX Compliance Requirements.
Pm - Sql Server Solution LeadHcl America () 2014 - 2015Noida, Uttar Pradesh, InManage, Facilitate, Lead, Assist, CollaborateExecute, Implement & Deliver assignment project(s) on-timeDefine & apply clear processesProcess ImprovementCommunication ProtocolBusiness ContinuityStakeholder ManagementPractical approach with an open communication that build trust relationship
Sql Server Dba - Service EngineeringMicrosoft May 2012 - 2015Redmond, Washington, UsBuilt a new scalable, high available SQL Server Cluster/FCI based "Delivery Platform" to facilitate, automate calculation and payment of Incentives to Partners & OEMs, participating in Microsoft's Channel Incentive Program. Managed this project and On-boarded this mature platform to Managed Services team.Built, Installed-Configured & Deployed an optimized Enterprise SQL Server Cluster, Standalone On-Prem and Azure Database Infrastructure.Provisioned & Configured SQL Azure/Azure SQL Database infra to support & On-board new business application programTook a lead role in providing Project, System, Production support and 24x7 On-Call Troubleshoot support, as part of a two member client DBA team.Migrated SQL Server 2008r2 FCI to SQL Server 2014 ClusterEngage cross-platform project teams, review BRD, FSD-TSD technical requirement and plan for (Volume Growth, Archiving Solution, SLAs, Data Sources, etc) of each project being on-boarded to our team's MS-SQL platform.Provide necessary training to onshore-offshore teams of assigned project. Ensure Operational requirements are being addressed/met.Perform Data Analysis, Systems Analysis & Gather Requirement for project. Provide a secure SQL Server Pre-Prod environment for Engg/Dev/Sopport teams to design, develop, test, maintain, upgrade-migrate, monitor, and deploy database application solutions. Manage System/Application status report to Business-Stakeholders. Utilize SCOM monitoring-Troubleshoot system & application issues.
Sql Server Ssis ConsultantTata Consultancy Services Oct 2011 - Mar 2012Mumbai, Maharashtra, InAs the sole SSIS consultant for this project, I designed & developed the SSIS package Promo Pricing application to automate the delivery of sales promotion for all Home Depot's retail stores in Canada. The SSIS application integrates a OLTP SQL Server application with the Planogram Promotion Manager system, Print, Mail, & flyer vendors.
Sql Server Dba/Ssis LeadThe Home Depot 2011 - 2012Atlanta, Georgia, UsIntegrate & automate the OLTP SQL Server database application, with the Planogram Promotion Manager system to support Home Depot Canadaβs business users, in their retail store advertising, promotion & sales effortsDesigned & Developed the SSIS Promo Pricing project for THD Canada (The PPM application leverages the power of MSBI stack to automate and support Sales Promotion Program for all their retail stores in Canada)
Google Maps Quantitative Data-Quality AnalystGoogle 2010 - 2011Mountain View, Ca, UsAnalyze metrics, recommend operational improvements based upon data analysis. Employ proprietary algorithms and perform data analytics & audit to optimize data quality and enrich user experience of Google Maps.
Project Coordinator LiasonAccenture 2008 - 2009Dublin 2, Ieβ’I managed a Multi-million dollar platform-integration and migration of marketing campaign execution project for a leading Seattle financial services firm β’Delivered an enterprise level SQL Server application solution that support the bankβs marketing campaign list execution program to generate new business and grow-retain existing customer base.β’Implemented comprehensive database management and migration from SQL to Oracle/Unica.
Sql Server Dba / Project LiasonWamu / Jpmorgan Chase 2007 - 2009New York, Ny, UsProject managed the Marketing Strategy departmentβs delivery platform integration and marketing campaign execution process, across the Bankβs four core Lines of Business. Responsible for timely, accurate campaign development, deliverables & ensure ZERO post-production defects. Developed a BI Solutions to access various bank applications, heterogeneous data source to generate cross-sell opportunities for eligible customers and prospects. Execute lists, segment data & generate customer lead, which feeds into various marketing delivery channels.Liaise with off-shore team and established handoff & communication protocol, to ensure timely & effective project execution and deliverable.Jr. Sql Server DbaInfovtechnologies 2006 - 2007
Branch-Premier Relationship Manager-Investment Consultant; Server AdministratorHsbc Retail Banking And Wealth Management () 1996 - 2006London, Gb
John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π Skills
John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π Education Details
-
Bellevue College Continuing EducationData Modeling/Warehousing And Database Administration
Frequently Asked Questions about John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π
What company does John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π work for?
John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π works for Osos-Wa
What is John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π's role at the current company?
John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π's current role is Database Administrator - Build/migrate to next Gen Az SQL MI at SOS.
What is John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π's email address?
John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π's email address is jo****@****hoo.com
What schools did John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π attend?
John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π attended Bellevue College Continuing Education.
What skills is John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π known for?
John K - Manage Azure_Sql Server Db β Modernize On-Prem And Migrate To Cloud. Yes π has skills like Microsoft Sql Server, Database Administration, Data Migration, Business Intelligence, Sql, Ssrs, Microsoft Certified Technology, Databases, High Availability, Sql Clustering, Disaster Recovery, Project Management.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records Γ $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial