Senior Database Administrator Job in Anblicks

Title: Senior Database Administrator.

Required Skills:

Experience: 10-20 years would be preferable. Knowledge details are:

• Administration
• Always On, High Availability Strategies, SSIS, SSRS, BK and Restore, Auditing,
• Partitioning Tables, Monitoring Enviroments, Troubleshoot Outages, Install Config
• Environments
• Performance Tuning
• Temp Tables, CTE, Execution Plan, Indexing Strategy, Data Access Pattern,
• Isolation Levels, Indexed Views, Statistics KPI
• SQL Development
• Cursors, Functions, Batch Operations, XML Parsing, Stored Procedures, Triggers,
• Error Handling, View.
• Physical Design
• Partitioning Views, Vertical Partitioning, Horizontal Partitioning
• Others
• Familiarity with SQL security techniques such as data encryption at the column
• level, Transparent Data Encryption (TDE), signed stored procedures, and
• assignment of user permissions
• Data modeling to visualize database structure
• Good understanding of SSRS reports would be added advantage.
• Exposure to Continuous Integration and Continuous Delivery (CI/CD)
• application deployment cycle.
• Understanding of Enterprise Frameworks, Release procedures, understanding
• of development environments.
• 
  
• Key Responsibilities:
• Maintain and configure the SQL Servers along with responsibility of regular
• automatic backup, replication, partitioning, mirroring, azure configuration, DB
• deployment
• Designing databases and ensuring their stability, reliability, high availability and
• performance.
• Design, create, and implement database systems based on the end user's
• requirements.
• Trouble outage and monitoring on daily basis and generate the server health
• report.
• Support SSRS/SSIS packages for our various ad-hoc processes.
• Improve application's performances.
• Prepare documentations for database applications.
• Memory management for database systems.
• Develop database schemas, tables and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective
• measures.
• Create complex functions, scripts, stored procedures and triggers to support
• application development.
• Take regular database backup.
• Test databases and perform bug fixes.
• Provide authentication and authorizations for Database
• Develop best practices for database design and development activities.
• Ability to quickly analyse existing T-SQL code and make improvements to
• enhance performance, take advantage of new SQL features, close security
• gaps, and increase robustness and maintainability of the code.
• Take on technical leadership responsibilities of database projects across
• various scrum teams.