Database Framework team is responsible for demonstrate all the best Practices & Process for databases. Also this team is responsible to release the database components for any project releases and handle the customer complaints related to Database.
Database administrator will be part of Database Framework team and will be responsible for database design, performance analysis and tuning, administration activities, investigating the customer complaints.
Also help the product service engineers while performing database upgrade in the customer site. DBA will be working on Disaster recovery & High availability to provide different options to the customer needs.
Analyze business requirements from product management and develop enterprise data models.
Work closely with development teams and cross functional teams for multiple projects.
Keep the best practices and process for development activities and share with other domain team / DBAs.
Implement database modules for SQL Server, including database schemas and complex & optimized stored procedures, and develop unit test-
drivers and conduct appropriate testing.
Communicate with cross functional teams to capture requirements and convert them to support system architecture
Develop database maintenance plans for multiple environment by considering partitioning maintenance, gathering and update statistics, managing and optimize usage of disk space and memory, backup and restore, automated job setup, etc.
Support performance optimization activities related to product modules
Create High Availability and disaster recovery plan.
Create high availability solutions with different options based SLA.
Research, experiment, and utilize leading Big Data methodologies, such as Hadoop, HIVE, Spark and Microsoft Azure
Qualifications Required :
BE, M.Sc. or MCA in Computer Science or related discipline.
Experience (Years) : 6+ years
Technologies required :
4 to 5 years in SQL Server DBA
2 years in NoSQL / Big data
2 to 3 years in any programing language
Expert level knowledge on Microsoft SQL Server (2014 / 2019), NoSql (MongoDB, Cosmos DB) and Azure SQL.
Must have deep understanding of database server internals.
Demonstrates solid understanding of database modeling, data warehousing principles and design considerations for multidimensional databases.
Strong proficiency in the areas of Database normalization, Query optimization, Transaction processing, Database tuning
Database performance tuning with SQL queries and Database configurations
Strong logical and problem-solving skill set.
Experience in implementing High availability / Disaster recovery / Clustering
Exposure to source code repository and management system like TFS, Git
Experience in Hadoop, HIVE, Spark.
Become part of our team
At Varian, our culture is centered on fostering the creative potential of every employee through teamwork and collaboration.
Our technologies touch millions of lives every day, and this inspires us to do our best work every day. By using your talent, ambition and creativity, you can build a career that allows you to make a real difference in people’s lives.
You’re just one click away from the most impactful work you’ll ever do. Apply now and join our mission to help save lives.
Someone, somewhere, will be glad you did.