Understand complex SQL Server designs to share ownership and optimize a mix of on-prem physical and Azure IaaS SQL Server environments
Manage physical and Azure Iaas SQL Infrastructure and optimization
Develop and help drive forward Azure SQL IaaS to Azure SQL PaaS
Maintain SOX compliance and GCC controls within SQL environments
Support several highly active custom application and software development groups in a controlled Dev / Test / Prod / DMZ / DR
Interact with internal and external customers to establish database requirements, designing and implementing complex resolutions
Analyze, predict, and resolve database, system, storage and application issues, working with all levels of Infrastructure and Application teams.
Drive forward new innovative SQL / Azure features and functionality
Maintain and improve DR strategies and DBA Admin code
Support extensive DTS and SSIS implementations
Lead Application SQL Support and OS / SQL upgrades and migrations
Monitor SQL job failures, debugging, root cause analysis, resolution, documentation and escalation of priority issues
Optimization of existing and new complex TSQL code
Engage in continuous process and technology improvement
Continual study of SQL Server / Azure trends emerging technologies
Rotating on-call (24 / 7) support of production SQL environment
Support development and deployment of software applications
Optimize and tune T-SQL application query performance
Manage, maintain, and optimize 100 sql instances across multi-tiered SDLC environment
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 overnight North America hours
Optimize T-SQL, enhance application query performance and debug job / integration issues
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 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 Developers
Configure, support, optimize, and evolve SQL Server configurations
Must 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.
Responsible to maintain compliance with SOX controls on applications, data, and SQL Servers configuration.
Writing technical specifications and documentation.
Passionate advocacy for SQL Server and Azure technologies, motivated and driven to research, enhance, optimize Azure and SQL Server implementations.
Collaboration with stakeholders
Extensive custom application development support and collaboration with multiple DevOps software development groups.
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.
Work closely with all levels of IT; sharing the vision, priorities, and projects of application and infrastructure teams providing exceptional service and value
Flexible work schedule to overlap for collaboration with colleagues in North America
Ability to travel to North America for training and development with IT colleagues
Bachelor’s Degree in Computer Science / Engineering
10 years IT experience, minimum 5-7 years SQL DBA experience required. Software engineering or systems engineering background preferred.
3+ years Azure experience preferred.
Self-motivated, driven, thoughtful, proven, professional Enterprise SQL Server DBA background required
Candidate Profile :
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 supporting custom software development
Expertise in SQL Server Integration Services
Expertise in SQL Server Reporting Services
Expertise in SQL Server Analysis Services
Expertise in SQL Server Data Transformation Services
Expertise in SQL Server Replication
Experience with globally distributed SQL Server Architecture
Experience in mid-large IT Organization with active DevOps
Experience / Expertise in Azure SQL Server IaaS & PaaS
Expertise in SQL Server Clustering
Expertise in Windows Server required, Linux experience a plus
Experience with Oracle / SQL integrations
Experience / Expertise with PowerShell
Microsoft Certification a plus
Rewarding experience. Meaningful outcomes.
Making a difference in people's lives through design and implementation of leading network technologies. That's 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