Vinirma Consulting

0 jobs

About Us

Nair Systems is currently looking for Database Administrator for our Qatar operations with the following terms & conditions.

QUALIFICATIONS, EXPERIENCE

Required Qualifications:

  • Graduation in Computer Science / Related fields.
  • Microsoft Certified Database Administrator (MCSA - SQL 2016 or above)
  • Microsoft Azure Fundamentals
  • Trained Oracle Database Administrator
  • Trained PostgreSQL Administrator (Added Value)
Additional qualifications:
  • English - Fluently Oral & Written
  • Excellent Computer literacy
Required Experience:
  • Having around 6+ years of experience as SQL Server DBA with SSRS, SSIS and Power BI.
  • Can support on PostgreSQL DBA and L1 support for Oracle Database as well.
PROFESSIONAL SKILLS:
  • Strong organizational skills
  • Problem solving skills
  • Analytical thinking
  • Professional behavior
BEHAVIORAL SKILLS
  • Excellent communication skills
  • Effective teamwork
  • Positive attitude and personal motivation
KEY ACCOUNTABILITIES/RESPONSIBILITES
  • Expertise on installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2008 R2/2012/2014/2019/2022
  • Installing SQL Server Stand-alone and clustered instances as per CIS Standards.
  • Configure SQL DB servers with Always On high availability feature and usage secondary replica for read -only connections and adding newly created databases to existing AAG.
  • Strong knowledge on Windows Failover cluster and Configuration of SQL failover cluster, SQL Always-On Feature with best Industry standards.
  • Very Strong knowledge on use of Always-On secondary for Read only connections like SSRS, SSIS, Power BI Tools.
  • Upgrading/Migrating SQL Servers from Old version to New Version which is latest.
  • Apply the Latest SP\CU Patches on SQL Servers across all versions.
  • Fixing production DB issues escalated by Application support team
  • Worked on design High Availability and DR options.
  • Standardize all the servers and implemented best hardening practices.
  • Query optimizing and Performance Tuning, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Fixing linked server issues and permission issues on object level.
  • Creating Table level partitions for Big size specially for data warehouse.
  • Experience in Importing and Exporting SQL Server data. (SSIS)
  • Worked on Rebuild indexing and update statics, Integrity check of database.
  • Created SQL Server Audit for any change on Server and DB level by any one of authorized persons.
  • Configuring database mail, creating and managing maintenance plans and jobs
  • Proactively managing the Database Fragmentation to optimize the Application performance weekly basis.
  • Troubleshooting and resolving Database Integrity, Blocking and Deadlocking issues and DB Availability issues.
  • Follow ITIL Process and Meet the SLA (Service Level Agreement) established.
  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
  • Using Scripting language like PowerShell, VBScript for Alerts and managing the SQL Database baselines.
  • Strong experience in mentoring team members and writing documentation.
  • Can build the SQL Servers Inventory, DB Inventory, patching status, other reports which is Management required to know.
  • Can manage MS SQL Server on Linux platform.
  • Expertise in designing the new Database Servers based on business requirements.
  • Expertise in Capacity planning for the database environment.
  • Created Linked Servers between SQL Server & Oracle Database systems.
  • Hands on experience in Database Backup and Recovery procedures.
  • Checking the status of Backup troubleshooting the failed backups and Restoration of databases
  • Perform scheduled maintenance and support release deployment activities after office hours.
  • Use of extended events to capture the DDL events on the Database.
  • 24 X 7 Production Database on Call Support.
Apart from above primary roles, should support on below roles as well.
  • L1 Support for Oracle database management.
  • Support for PostgreSQL Database management.
  • Power BI Reporting management and can build the reports.
  • Expertise with working on Linux Servers
KEY COMPETENCIES
  • Using tools (Nagios, Splunk, Cisco AppDynamics APM, Oracle OEM, PostgreSQL Enterprise Manager, etc.) interactively to monitor the DB Servers health and performance, etc.
  • Actively participates in team. Encourages co-operation. Aware of the needs of others and responds flexibly. Shares information and supports other team members.
  • Will handle the crisis with confidence/resilience.
  • Takes balanced view of situations incorporating different perspectives. Seeks alternative viewpoints. Recognises priorities, weighs up different options and evaluates risks.
  • Has the ability to recognise information needs and identify and utilise appropriate information sources.
  • Able to achieve results in a quality, timely, and cost-effective way.
  • Sets personal goals which are challenging but achievable. Pursues these with energy, persistence and determination. Enthusiastic and committed to improving personal performance levels.
  • Has actively sought to learn new things on own initiative like PostgreSQL, MS Azure, Power BI tool, PowerShell, etc.
  • Will work independently and solves the problems in the environment and fix them permanently.
  • Have Knowledge on cloud technologies like MS Azure Cloud, Google Cloud, AWS.
  • Having knowledge on New Technologies which is currently trending in Market:
  • Containers / Dockers
Joining time frame: 2 weeks (maximum 1 month)

Should you be interested in this opportunity, please send your latest resume in MS Word format at the earliest at nishanthini.suda@nairsystems.com