Cyient is one of the world's leading rail engineering solutions partner repeatedly trusted by rail majors to address complex engineering challenges across the design-build-maintain life cycle. Our Design solutions include rolling stock project and product engineering support and signaling application engineering. Our Build offering includes product localization, life extension support, and electronics manufacturing. Our Maintain offerings focus on enhancing the efficiency and availability of assets through data analytics-led solutions.
Needs to be a Database Administrator of around 8-10 years of experience in SQL server.
Education qualification: Bachelors or Masters in Computers.
Updating and amending existing databases
Setting up and testing new database and data handling systems
Monitoring database efficiency
Sustaining the security and integrity of data.
Installing versions of the SQL Server and its tools and any other tools that access the database to provide support to the application.
Maintenance of databases (SQLServer), designing the data model, developing the schemas and other SQL PLSQL database objects.
Creating High availability architecture- 4- node architecture
Creation and maintenance of Archieve and restore processes, backup & recovery and monitor database.
Creating Logical and Physical data models using SQLSERVER by getting involved in interactions with team.
To work on creating database objects like tables, creating constraints by understanding the relationships between tables, Partitioning tables and views.
To work on creating database objects like stored procedures, functions, cursors, indexes (for faster retrieval and improved query performance), triggers, packages, synonyms, sequences, roles and granting privileges. Linking the server through the linked server's concept in SQL Server.
Creating complex query definitions that allow data to be extracted
Assisting in database design
To write complex queries with join conditions, sub queries, correlated sub queries and set operators like Union, Union all, Intersect, and Minus.
To work on the advanced features like collections, native dynamic SQL, types, nested tables, varrays and BULK operations.
To Work on development of Reports using SSRS, working on PLSQL objects like procedures, functions, triggers for generating the reports.
Creating Session (Static & Dynamic) and Repository (System and Non-system) variables for reports.
Estimation planning activities responsible for developing code as per requirements.
Application maintenance and enhancement, investigate, analyse and document reported defects.
Day to day administration of database like rebuild indexes, user creation, resizing of datafiles.
Performance tuning activities both at database level and also at Application level, To ensure that the ongoing system does not break.
Recommended modifications in the existing PLSQL Objects.
Database review, database validation and database refresh.
User Management, Memory Management, looking into connectivity issues.
Skills & Experience
Dynamic SQL, Microsoft SQL Server Administration, Sql Dba, SQL Server
Cyient is an Equal Opportunity Employer.
Cyient recruits, employs, trains, compensates, and promotes regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, veteran status, and other protected status as required by applicable law. We are proud to be a diverse and inclusive company where our people can focus their whole self on solving problems that matter.