Job Description

Nair Systems, is a QFC based, boutique leading edge technology consulting and professional services firm focusing on Digital Banking, Artificial Intelligence, Big Data & Data Analytics, Cyber Security, Blockchain and Cryptocurrency and Robotic Process Automation. 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 SPCU 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 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 [HIDDEN TEXT]

Full time