Ms SQL Database Administrator

3 weeks ago


Vellore, India FactEntry Data Solutions Pvt Ltd Full time

**MSSQL DBA / Developer**

**Key skills we are looking for**
- **Performance **optimisation and troubleshooting
- Handling large datasets and large databases - SQL Partitioning, data archivals
- Have both SQL DBA and SQL developer skillsets
- Installation, designing databases, HA/DR and capacity planning
- Designing scalable code which can handle present and future processing requirements
- Automate routine tasks and help reduce manual efforts
- Leadership skills, positive attitude, strong interpersonal and communication skills

**Roles and Responsibilities -**

Install, configure, administer and upgrade MS SQL databases

Good knowledge and practical experience in handling SQL 2019, SQL 2017 databases

Monitor and troubleshoot MS SQL database issues to ensure smooth BAU operation

Develop efficient queries, perform in-depth analysis, and resolve performance issues with existing queries

Implement High Availability (HA) and Disaster Recovery (DR) options

Manage user security, including logins, roles, and privileges

Monitor database growth, health, and capacity planning for optimal performance

Good Practical knowledge in designing ETL solutions like importing data from JSON, Excel, PIP files to SQL tables

Design and implement database relationships, including building tables, foreign keys, primary keys, triggers and other database objects

Establish and adhere to backup and recovery policies and procedures

Maintain documentation and ensure to be compliant with our coding standards for the database environment

Collaborate with the Application development team to design and implement efficient solutions

Optimize, troubleshoot and resolve database performance issues including performance bottlenecks and data inconsistencies

Work closely with stakeholders to understand their data requirements and provide technical solutions

To create and modify database tables using CRUD SQL commands

Automate routine tasks and help achieve automation excellence

Document database processes, procedures, and standards for future reference

**Skills Required**:
Extensive knowledge of Database Administration for MSSQL Server, including a solid understanding of database architecture

Strong proficiency in installation, configuration, and CU upgrades of Microsoft SQL Server

Excellent proficiency in T-SQL coding, performance tuning and optimisation

Demonstrated ability to troubleshoot and resolve database problems effectively

Familiarity with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server

Sound knowledge of backup and recovery policies and procedures

Write T-SQL stored procedures to track performance metrics, monitor and improve the environment

ETL process, data imports from various sources (PIP file, Excel, JSON) to database tables

Work closely with analysts and other teams and advise best T-SQL coding practices

Good knowledge in data modeling, capacity planning, scaleup including an understanding of all normalized forms, design and development of stored procedures, views and triggers

Excellent attention to detail, ability to detect and correct problems within T-SQL scripts and ability to work with complex queries and data

Monitor and troubleshoot job failures, setup maintenance plans, alerts

Good Knowledge in Agile development process

A thorough understanding of Tables, Stored Procedures, Indexes, Transactions, Views

Understand table indexing and query strategies, database objects maintenance and performance issues to handle heavy traffic loads

Participate in code reviews and provide feedback to ensure high-quality code

Solid knowledge of database design principles and data modeling

Build Positive working relationships with colleagues

Excellent problem-solving and analytical skills, good communication and collaboration skills

**Qualification**: Bachelor's degree in Computer Science, Information Technology, or a related field

**Additional Skills**

Related licences, certifications, and trainings

Optional - Familiarity with NoSQL databases and cloud technologies like AWS and Big Data

Optional - SSIS, SSRS, or SSAS exposure

Optional - Experience in workflow process tools like JIRA

Optional - Experience in Excel, Gsheet, especially in Pivot tables

Optional - Experience in Python, VB or PHP coding

Optional - Experience in financial markets is an added advantage

**Salary**: ₹500,000.00 - ₹1,000,000.00 per year

**Benefits**:

- Health insurance
- Provident Fund

Schedule:

- Day shift

**Speak with the employer**
+91 9944686504



  • Vellore, India FACTENTRY DATA SOLUTIONS PRIVATE LIMITED Full time

    Requirement Name: MS-SQL DBA / Developer Experience: 4-5 years & above **Job Description**: We are seeking a skilled and experienced MS-SQL DBA / developer to join our team. You will be responsible for managing and optimizing our Microsoft SQL Server databases, ensuring their performance, security, and availability. Your expertise in database...


  • Vellore, Tamil Nadu, India FactEntry Full time

    Responsibilities: Installation, configuration and upgrading of Microsoft SQL Server / MySQL software and related products. Experience with Database Administration for MSSQL Server versions 2008, 2012 and 2016 with a strong understanding of database structure Experience in Performance Tuning, Application tuning and Optimization (PTO), using monitoring and...


  • Vellore, India OTOMATIKS Full time

    __ - **Key Responsibilities**:_ - _Perform general office administrative tasks such as filing, scanning, and copying documents._ - _Manage and schedule appointments, meetings, and travel arrangements._ - _Prepare and edit correspondence, reports, and presentations._ - _Maintain office supplies inventory by checking stock and ordering new supplies as...


  • Vellore, India Balsam Academy Full time

    **Reports To: Assistant Head of Operations** **POSITION OVERVIEW**: The Facility Manager cum System Administrator plays a pivotal role in overseeing the robust functioning of the school's physical and IT infrastructure. Reporting to the Assistant Head of Operations, this role involves supervising and guiding the Logistics cum Infra Officer and is...


  • Vellore, India Hawaii Store Full time

    As an Admin and Account Assistant, your role is to provide support to the administrative and accounting functions within an organization. Your responsibilities may vary depending on the specific requirements of the company you work for, but here is a brief overview of what your role may involve: Administrative Support:Managing and organizing paperwork,...


  • Vellore, India Brigade LED Pvt Ltd Full time

    **Job description**: Calling existing and potential customers to persuade them to purchase company products and services. Accurately recording details of customers’ purchase orders. Processing all customer purchases accordingly.Generating promising leads for the outside sales team to pursue using sales scripts proffered by the company to drive sales and...


  • Vellore, India Brigade LED Pvt Ltd Full time

    **Job description**: Calling existing and potential customers to persuade them to purchase company products and services. Accurately recording details of customers’ purchase orders. Processing all customer purchases accordingly.Generating promising leads for the outside sales team to pursue using sales scripts proffered by the company to drive sales and...


  • Vellore, India KHEIPL Full time

    **Job brief** **Requirements and skills** - BSc Physics / BSc Maths or equivalent and additional computer training or certification will be an asset - Experience with **MS Office (MS Excel, MS Word, MS Power point)** and data programs - Experience using office equipment, like Printing and scanning - Typing speed and accuracy - Familiarity with...

  • L1- Admin Associate

    3 months ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...


  • Vellore, India Wonderworth Solutions Full time

    Wonder Worth Solutions Fresher _India_, _Vellore_ February 21, 2024 - March 30, 2024 HR **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office...

  • L1- Admin Associate

    6 days ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...

  • L1- Admin Associate

    4 weeks ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...

  • L1- Admin Associate

    3 weeks ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...

  • L1- Admin Associate

    2 weeks ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...


  • Vellore, India Wonderworth Solutions Full time

    Wonder Worth Solutions Fresher NO.47, ARNI ROAD, KOSAPET, VELLORE, 632001 _India_, _Vellore_ March 13, 2024 - April 30, 2024 HR **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main...

  • L1- Admin Associate

    4 weeks ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...

  • L1- Admin Associate

    3 weeks ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...


  • Vellore, India Wonderworth Solutions Full time

    Wonder Worth Solutions Fresher No.47, Arni Road, Kosapet, Vellore, 632001 _India_, _Vellore_ March 5, 2024 - April 30, 2024 HR We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties...


  • Vellore, India Wonderworth Solutions Full time

    Wonder Worth Solutions Fresher No.47, Arni Raod, Koaspet, VEllore, 632001 _India_, _Vellore_ April 2, 2024 - April 30, 2024 HR **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main...

  • L1- Admin Associate

    2 weeks ago


    Vellore, India Wonder Worth Solutions Pvt Ltd Full time

    **Role Summary** We are looking for an Administrator to support our Human Resources department in WWS where You will act as the first point of contact for admin -related queries from employees and external vendors. Your main administrative duties will include office general administration, maintaining of physical assets, maintaining personnel records,...