Vinirma Consulting
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)
- English - Fluently Oral & Written
- Excellent Computer literacy
- 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.
- Strong organizational skills
- Problem solving skills
- Analytical thinking
- Professional behavior
- Excellent communication skills
- Effective teamwork
- Positive attitude and personal motivation
- 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.
- 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
- 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
Should you be interested in this opportunity, please send your latest resume in MS Word format at the earliest at nishanthini.suda@nairsystems.com