SQL DBA Administrator, Remote North America

Ciena

Hanover Maryland

United States

Information Technology
(No Timezone Provided)

Since 1992, Ciena has been driven by a relentless pursuit of network innovation. We believe in a network that grows smarter, more agile, and more responsive every day. This means that when you digitally interact in your world - picking up the phone, streaming video, texting a friend or loved one - your interactions are being enabled by Ciena technologies. Ciena makes your social / entertainment / business existence REAL.DIMENSION & SCOPEMust possess extensive production SQL Server design, support, and administration experience in a large enterprise and apply those skills with a proven ability to prioritize work across several complex tasks simultaneously.Implements DBA best practices and optimizations across a complex continually evolving Azure/SQL Server environment. Understand and support complex backend integrations across multiple business technology platforms; leading ad-hoc cross functional efforts to troubleshoot and resolve production issues along with new features under development. Support the SQL development of custom applications within SDLC, ITIL, Change Control procedures in Development, Validation, Production, DMZ, and DR environments.Demonstrate a strong work ethic and the ability to work flexible, long, sometimes odd hours in support of development, validation, and production initiatives across a globally distributed workforce. Demonstrate strong documentation, communication skills and effectively work with various IT groups across several different time zones.SPECIFIC RESPONSIBILITIESUnderstand complex SQL Server designs to share ownership and optimize a mix of on-prem physical and Azure IaaS SQL Server environmentsManage physical and Azure Iaas SQL Infrastructure and optimizationDevelop and help drive forward Azure SQL IaaS to Azure SQL PaaSMaintain SOX compliance and GCC controls within SQL environmentsSupport several highly active custom application and software development groups in a controlled Dev/Test/Prod/DMZ/DRInteract with internal and external customers to establish database requirements, designing and implementing complex resolutionsGood understanding of Azure cloud services like VNET, NSGs, Azure Automation, runbook etc.Analyze, predict, and resolve database, system, storage and application issues, working with all levels of Infrastructure and Application teams.Maintain and improve DR strategies and DBA Admin codeSupport extensive SSIS/SSAS/SSRS implmentationsLead Application SQL Support and OS/SQL upgrades and migrationsMonitor SQL job failures, debugging, root cause analysis, resolution, documentation and escalation of priority issuesOptimize and tune T-SQL application query performanceConfigure, support, optimize, and evolve SQL Server configurationsOptimization of existing and new complex TSQL codeContinual study of SQL Server/Azure trends emerging technologiesGood understanding of Azure cloud platformWorking knowledge of powershell, python, json, Azure Devops, functions etc.PRIMARY DUTIES AND RESPONSIBILITIES:Manage, maintain, and optimize ~100 sql instances across multi-tiered SDLC environmentProvide 24/7 support to a production environment, and critical development operationsSupport active globally distributed DevOps development and deployment of custom applicationsProvide primary production on-call support during overnight North America hoursFlexible work schedule to overlap for collaboration with colleagues in North America and IndiaOptimize T-SQL, enhance application query performance and debug job/integration issuesIndependently drive forward SQL Server DBA functions to continually improve Ciena SQLSupport Azure IaaS and drive forward upgrades from IaaS>PaaS (Azure SQL database, Azure SQL DataWarehouse, Azure Data Factory, Azure Data Lake, BigData technologies)Configure, support, and optimize SQL Server configuration, providing full stack support of SQL Database platforms while deeply collaborating with local and off-shore Software DevelopersWork closely with all levels of IT; sharing the vision, priorities, and projects of application and infrastructure teams providing exceptional service and valueAboutCienaCienais a network strategy and technology companywith apassion to provide an experience, to you and our customers that is as rewarding as the outcome.We attract the best and brightest- those with outstanding talent, motivation, and the right attitude to contribute to our success. Our culture balances our openness and informality with professionalism and trust and is built on the foundation of our core values: Customer First, Integrity, Velocity, Innovation, and Outstanding People.Ciena enables everyone to have a voice and a network that supports them while on the journey to discovering theirpassion and purpose. We trusteach individualto do what they can to reach their full potential and make an impact on the business, whenever, wherever they are in the world.With Ciena's highly innovative, forward-thinking businesspractices, we reward people for pushing the boundaries.Unlock your potential at Ciena!Being part of our commitment to diversity and inclusion, we want to foster an environment that values and respects all individual's strengths, perspectives, ideas, and ability to meet the needs of our customers globally. Ciena values the diversity of its workforce and respects its employees as individuals, regardless of race, ethnicity, religion, gender, age, national origin, disability, sexual orientation, veteran or marital status or any other category protected by applicable law. We do not tolerate any form of discrimination. Cienais also committed to compliance with all fair employment practices regarding citizenship and immigration status. If contacted in relation to a job opportunity, you should advise Ciena in a timely fashion of the specific accommodation measuresrequiredforyou to be assessed in a fair and equitable manner.We do not charge any fee for employment and the same applies to the Recruitment Partners we work with. Additionally, we do not ask for any refundable security deposit to be paid in bank accounts for employment purposes. We request candidates to be cautious of misleading communications and not pay any fee/ deposit to individuals/ agencies/ employment portals on the pretext of attending Ciena's interview process or seeking employment with us.

SQL DBA Administrator, Remote North America

Ciena

Hanover Maryland

United States

Information Technology

(No Timezone Provided)

Since 1992, Ciena has been driven by a relentless pursuit of network innovation. We believe in a network that grows smarter, more agile, and more responsive every day. This means that when you digitally interact in your world - picking up the phone, streaming video, texting a friend or loved one - your interactions are being enabled by Ciena technologies. Ciena makes your social / entertainment / business existence REAL.DIMENSION & SCOPEMust possess extensive production SQL Server design, support, and administration experience in a large enterprise and apply those skills with a proven ability to prioritize work across several complex tasks simultaneously.Implements DBA best practices and optimizations across a complex continually evolving Azure/SQL Server environment. Understand and support complex backend integrations across multiple business technology platforms; leading ad-hoc cross functional efforts to troubleshoot and resolve production issues along with new features under development. Support the SQL development of custom applications within SDLC, ITIL, Change Control procedures in Development, Validation, Production, DMZ, and DR environments.Demonstrate a strong work ethic and the ability to work flexible, long, sometimes odd hours in support of development, validation, and production initiatives across a globally distributed workforce. Demonstrate strong documentation, communication skills and effectively work with various IT groups across several different time zones.SPECIFIC RESPONSIBILITIESUnderstand complex SQL Server designs to share ownership and optimize a mix of on-prem physical and Azure IaaS SQL Server environmentsManage physical and Azure Iaas SQL Infrastructure and optimizationDevelop and help drive forward Azure SQL IaaS to Azure SQL PaaSMaintain SOX compliance and GCC controls within SQL environmentsSupport several highly active custom application and software development groups in a controlled Dev/Test/Prod/DMZ/DRInteract with internal and external customers to establish database requirements, designing and implementing complex resolutionsGood understanding of Azure cloud services like VNET, NSGs, Azure Automation, runbook etc.Analyze, predict, and resolve database, system, storage and application issues, working with all levels of Infrastructure and Application teams.Maintain and improve DR strategies and DBA Admin codeSupport extensive SSIS/SSAS/SSRS implmentationsLead Application SQL Support and OS/SQL upgrades and migrationsMonitor SQL job failures, debugging, root cause analysis, resolution, documentation and escalation of priority issuesOptimize and tune T-SQL application query performanceConfigure, support, optimize, and evolve SQL Server configurationsOptimization of existing and new complex TSQL codeContinual study of SQL Server/Azure trends emerging technologiesGood understanding of Azure cloud platformWorking knowledge of powershell, python, json, Azure Devops, functions etc.PRIMARY DUTIES AND RESPONSIBILITIES:Manage, maintain, and optimize ~100 sql instances across multi-tiered SDLC environmentProvide 24/7 support to a production environment, and critical development operationsSupport active globally distributed DevOps development and deployment of custom applicationsProvide primary production on-call support during overnight North America hoursFlexible work schedule to overlap for collaboration with colleagues in North America and IndiaOptimize T-SQL, enhance application query performance and debug job/integration issuesIndependently drive forward SQL Server DBA functions to continually improve Ciena SQLSupport Azure IaaS and drive forward upgrades from IaaS>PaaS (Azure SQL database, Azure SQL DataWarehouse, Azure Data Factory, Azure Data Lake, BigData technologies)Configure, support, and optimize SQL Server configuration, providing full stack support of SQL Database platforms while deeply collaborating with local and off-shore Software DevelopersWork closely with all levels of IT; sharing the vision, priorities, and projects of application and infrastructure teams providing exceptional service and valueAboutCienaCienais a network strategy and technology companywith apassion to provide an experience, to you and our customers that is as rewarding as the outcome.We attract the best and brightest- those with outstanding talent, motivation, and the right attitude to contribute to our success. Our culture balances our openness and informality with professionalism and trust and is built on the foundation of our core values: Customer First, Integrity, Velocity, Innovation, and Outstanding People.Ciena enables everyone to have a voice and a network that supports them while on the journey to discovering theirpassion and purpose. We trusteach individualto do what they can to reach their full potential and make an impact on the business, whenever, wherever they are in the world.With Ciena's highly innovative, forward-thinking businesspractices, we reward people for pushing the boundaries.Unlock your potential at Ciena!Being part of our commitment to diversity and inclusion, we want to foster an environment that values and respects all individual's strengths, perspectives, ideas, and ability to meet the needs of our customers globally. Ciena values the diversity of its workforce and respects its employees as individuals, regardless of race, ethnicity, religion, gender, age, national origin, disability, sexual orientation, veteran or marital status or any other category protected by applicable law. We do not tolerate any form of discrimination. Cienais also committed to compliance with all fair employment practices regarding citizenship and immigration status. If contacted in relation to a job opportunity, you should advise Ciena in a timely fashion of the specific accommodation measuresrequiredforyou to be assessed in a fair and equitable manner.We do not charge any fee for employment and the same applies to the Recruitment Partners we work with. Additionally, we do not ask for any refundable security deposit to be paid in bank accounts for employment purposes. We request candidates to be cautious of misleading communications and not pay any fee/ deposit to individuals/ agencies/ employment portals on the pretext of attending Ciena's interview process or seeking employment with us.