Senior Analyst - SQL Server DBA
Ciena Corporation
Gurgaon
1d ago

Responsibilities

  • 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
  • General Activities

  • 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
  • Experience

  • 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
  • Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form