Senior Database Administrator

Expertise Contracting Co (Mangalore, KA, India) 3 days ago

Position: Database Administrator – Microsoft SQL Server

Education: BE / B.Tech in Computer Science or equivalent

Location: Mangalore

Duration: Permanent

Experience: 5+ years

Email: recruitment@expertindus.net

Technical Experience / Skills required

  • Strong experience on MS SQL DB, including roles as DBA, SQL Programmer and reports
developer using SSRS / third party reporting tools like Kendo.
  • Thorough working knowledge of database system concepts and design methods.
  • Expert in utilizing views, Constraints, Triggers, Joins, Temp Tables, Table Variable,
Functions, Batch Scripts and stored procedures.
  • Able to write queries for application integrations between ERP and third-party software
  • Experience with Performance Tuning and Optimization, using native monitoring and
troubleshooting tools
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Strong experience on Database backup, recovery and performance measurement /
optimization on MS SQL Server
  • Experience with MS SQL DB backups / restores and recovery models
  • Functional understanding of business processes and applications
  • Experience in build and release activities
  • Experience working with Windows server, including Active Directory

Requirements

  • Effective verbal and written communication skills
  • Willing to learn new technologies and have exposure to the current trends in programming
and other technologies
  • Ability to communicate clearly with technical, applications and operational staff to ensure
database integrity and security
  • Ability to work in a rapidly changing environment
  • Work effectively in a collaborative team environment, as well as independently
  • Critical thinker and problem solver, must have strong ERP experience
  • Must demonstrate keen problem-solving skills, ability to deal with complex situations and
recommend a course of action in addition to analyzing and interpreting data to arrive at
business solutions

Responsibilities

Configuration and Maintenance

  • Install, configure, test, upgrade and maintain Microsoft SQL database servers and
processes
  • Monitor and Manage system health and performance, to ensure high levels of
performance, availability, and security. Maintain database integrity.
  • Perform scheduled maintenance and support release deployment activities, after office
hours.
  • Proactively and reactively work towards increasing performance through hardware
reconfiguration, server configuration changes, or index/query changes
  • Conduct Regular database capacity planning related to database growth and system
utilization, trend analysis and predicting future database resource requirements.
  • Responsible for the improvement and maintenance of the databases to include roll-out and
upgrades.
  • Responsible for database design and implementation, including all elements of database
security implementation, user management and maintenance.
  • Ensure 24/7 availability and performance of the databases and supporting critical
production systems. Proactively monitor the database systems to ensure minimum
downtime. Work towards ensuring that the database environment is tuned for best
performance.

Security

  • Control database access permissions and privileges
  • Control and maintain access to reporting environment.
  • Ensure that the DB Server security setup adheres to business security requirements.

Programming

  • Analyze SQL queries and SPs and implement required performance improvements
  • Work with the development team on creating and updating stored procedures, views etc, to
support the ERP / Reporting needs of the business

Backup

  • Establish and maintain sound backup and recovery policy and procedures.
  • Ensure all database servers are backed up in a way that meets the business’s Recovery Point
Objectives (RPO)
  • Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)

Documentation

  • Document the company’s database environment and ensure the same is reviewed and updated
monthly.

Senior Database Administrator

Apply On Company Site
Back to search page
;