• United States Of America, Usa
  • Save Job
  • 10 - 13 Years
  • Posted : 16 days ago

Job Description:

Implement and advocate Azure/SQL best practices and optimizations across a complex continually evolving Azure/SQL Server environment
Administer and implement Azure IaaS/PaaS resources across SQL/Apps Resource Groups
Design and implement Azure Automation, ARM Templates, DevOps, CICD, Infra as Code
Develop Cloud and SQL Solution Architecture and Design Documentation, including detailed solution cost/budget requirements for Azure Cloud implementations
Manage deployments, design, debug, and optimization of Azure Cloud services across several application team environments spread across numerous subscriptions in many regions
Understand and support complex backend integrations across multiple technology platforms, leading ad-hoc cross functional efforts to troubleshoot and resolve production issues along with new features under development
Passionate advocacy for SQL Server and Azure technologies, motivated and driven to research, enhance, optimize Azure and SQL Server implementations
Extensive custom application development support and collaboration with multiple DevOps software development groups
Responsible to maintain compliance with SOX controls, and extensive custom encryption solutions on subset of applications, data, and SQL Servers configuration
Demonstrate strong documentation, communication skills and effectively work with various technology teams across several different time zones
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 in a fast-paced Agile development methodology

Specific Responsibilities

Understand complex SQL Server designs to share ownership and optimize a mix of on-prem physical and Azure IaaS SQL Server environments
Manage Azure IaaS SQL and Custom Apps Infrastructure and optimization
Setup/Test new Azure Service offerings for emerging solutions
Design highly available Azure multi-region environment with many subscriptions
Develop migration path from Azure SQL IaaS to Azure SQL PaaS
Drive forward new innovative SQL/Azure features and functionality
Support several highly active custom application and software development groups in controlled, audited Dev/Test/Prod/DMZ/DR environments
Interact with internal and external customers to establish Azure/SQL requirements, designing and implementing complex solutions to emerging opportunities
Analyze, predict, and resolve database, system, storage and application issues, working with all levels of technology within and across multiple Clouds
Maintain and improve DR strategy, design, and implementation
Support extensive DTS, SSIS, and Azure Data Factory Integrations
Monitor SQL job failures, debugging, root cause analysis, debug/fix, documentation and escalation of priority performance issue resolution
Optimization of existing and new complex TSQL code (sprocs, views, fn)
Engage in continuous process, technology learning and improvement
Continual study of SQL Server/Azure trends emerging technologies
Rotating on-call (12x7) support of production SQL environment
Support development and deployment of software applications
Configure, support, optimize, and evolve SQL Server configurations
Maintain SOX compliance and GCC controls within Azure SQL environments
Lead Application SQL Support and OS/SQL upgrades and migration to PaaS
Primary Azure Cloud contact for numerous application/infrastructure groups

Primary Duties and Responsibilities

Manage, maintain, and optimize ~100 sql instances across multi-tiered SDLC environment
Share ownership of Azure subscription design and implementation working with other IT customers to deliver next-gen Cloud Solutions to current and evolving challenges along with existing project plans
Provide 24/7 support to a production environment, and critical development operations
Support active globally distributed DevOps development and deployment of custom applications
Provide primary production on-call support during North America operating hours
Flexible work schedule to overlap for collaboration with global teammates in India office
Optimize T-SQL, enhance application query performance and debug job/integration issues
Configure, support, and optimize SQL Server configuration, providing full stack support of SQL Database platforms while deeply collaborating with local and off-shore Software Developers
Independently drive forward SQL Server DBA functions to continually improve Ciena SQL
Support Azure IaaS and drive forward upgrades from IaaS>PaaS (Azure SQL database, Azure SQL Data Warehouse, Azure Data Factory, Azure Data Lake, BigData, App Services and Storage)
Script deployment of Azure Cloud resources, adherence and advocacy of Cloud best practices
Cost forecasting analysis of Cloud solution proposals, including performance analysis/optimization
Work closely with all levels of IT; sharing the vision, priorities, and projects of application and infrastructure teams providing exceptional service and value

Technical Expertise

Expertise in TSQL Programming, Optimization, Tuning
Expertise in Custom Application Development Support
Expertise in SQL Server RDBMS (SQL2008-SQL2017)
Expertise in SQL Server configuration, optimization, design, troubleshooting, support, monitoring, features, and releases
Expertise in SQL SSRS, SSAS, SSIS, Replication and
Experience with globally distributed SQL Server Architecture
Experience in mid-large IT Organization with active DevOps
Expertise in Enterprise IT Apps/SQL/Azure solution design
Experience/Expertise in Azure SQL Server IaaS & PaaS deployment configuration, performance and cost optimization
Expertise in SQL Server Clustering and Always-On
Expertise in Windows Server required, Linux experience a plus
Experience with Oracle/SQL and multi-cloud integrations
Experience/Expertise with PowerShell, Terra Form, Python coding
Experience/Expertise with Azure Architecture and Administration
Microsoft Certification a plus

Education and Experience

Bachelors Degree in Computer Science/Engineering
10 years IT experience, minimum 5-7 years SQL DBA experience required 3 years Azure experience required Software engineering or systems engineering background preferred
Must possess extensive production SQL Server design, support, and administration experience in a large enterprise applying those skills with a proven ability to prioritize work across several complex tasks simultaneously
Must possess extensive implementation and ownership of Azure Cloud subscription, resource group, resource, network, security design and administration of IaaS and PaaS

Rewarding experience Meaningful outcomes

Making a difference in peoples lives through design and implementation of leading network technologies Thats what motivates us

A distinct way to work

Free thinking, free discussion, and collaboration are the norm Expect more satisfying outcomes - both personal and professional

Ciena values the diversity of our workforce and respects its employees as individuals, regardless of race, nationality, religion, sexual orientation, gender or age

Ciena is also committed to developing inclusive, barrier-free selection processes and work environments If contacted in relation to a job opportunity, you should advise Ciena in a timely fashion of the specific needs / accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner Information received relating to any specific needs / accommodation measures will be addressed confidentially

What you can expect from us

You will receive notification of your successful application
Successful applicants will be contacted by Talent Acquisition for an initial discussion
If suitable you will be considered for the short list and our formal interview process

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : IT-Hardware/Networking, Telecom
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 17th May 2020

Key Skills:

These free online tutorials may interest you

People who search this job also searched for the following Keywords

Sourced**

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status