SQL Dba Data Modeller

1 week ago

Gurugram Haryana, India Appsierra Full time

**Technical Skills**:

- 10+ years of experience on Database Management Systems, configures database parameters and prototype designs against logical data models.
- Defines data repository requirements, data dictionaries and warehousing requirements.
- To optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
- Experience/knowledge with Microsoft SQL Replication and CDC technology is must.
- Experience setting up and configuring HA (High Availability) / Replication/AlwaysOn. Preferably having researched and fine-tuned a setup so that the person understands what/why and can understand our needs and design/implement/configure a setup that meets client needs.
- Solid SQL Server DBA experience, in general.
- *The typical DBA skills / experience including DB maintenance, table/index/etc. maintenance, backups, monitoring, security, data dictionary, integrity checks, configuration, patching, and statistics, etc.
- Experience with SQL Server 2008/2012/2014/2016, preferably with multiple editions (Standard, Enterprise, etc.).
- Experience having installed and configured SQL Server instances in a similar capacity
- Strong SQL skills
- Strong Data Modeling skills both Logical/Physical Database Modeling knowledge
- Strong analytical and problem solving skills
- Excellent verbal and written communication skills
- Strong experienced with Microsoft tools and software (Visual Studio 2012/2015, SQL Mgmt. Studio, Microsoft Office, etc.)
- Experience with Data Warehousing and OLTP database management.
- Measure, track and meet SLA metrics (analytics cycle time, schedule, accuracy, rework, etc.).
- Assist in database performance tuning and troubleshooting database issues in both OLTP and EDW environments.
- Install, configure, and maintain critical SQL Server databases.
- Dimensional and relational based databases.
- Assist in the full range of SQL Server maintenance activities (for example):

- Backups, restores, recovery models, database shrink operations, DBCC commands, and Replication.
- Table, Index, etc. design, creation, and maintenance.
- On-going maintenance activities - working to plan and automate as much as possible.
- Increase availability and performance while at the same time reducing manual support time.
- Assist as part of the team designing, building, and maintaining the future state of Merchants database platforms:

- SQL Server versions, editions, and components.
- Database server configuration.
- Database and Data Model standards
- Business Continuity and High Availability strategy.
- Overall Data Architecture.
- Upgrade and Patching strategy.
- Knowledge in snowflakes, stored procedures is preferred.
- Knowledge in ETL Integration layer ,SSIS and SSRS.
- Installation and configuration of SSRS, SSIS and SSAS.

**Good to have**
- Deep Azure experience

**Process Skills**:

- General SDLC processes
- Understanding of utilizing Agile and Scrum software development methodologies
- Skill in gathering and documenting user requirements and writing technical specifications

**Behavioral Skills**:

- Good Attitude and Quick learner
- Well-developed analytical & problem-solving skills
- Strong oral and written communication skills
- Excellent team player, able to work with virtual teams
- Excellent leadership skills with ability lead and guide and groom the team
- Self-motivated and capable of working independently with mínimal management supervision
- Able to talk to client directly and report

  • DBA Architecht

    2 weeks ago

    Gurugram, Haryana, , India Overture Rede Full time

    Job Summary: The DBA will lead the overhaul of the existing SQL Server database to amodern, scalable SQL, PostgreSQL or other scalable backend on AWS. This role involvesdesigning and implementing the new database architecture, ensuring data integrity, optimizingperformance, and supporting the development team in translating old business logic to the...

  • MS SQL DBA + Developer

    2 weeks ago

    Gurugram, India Clover Infotech Private Limited Full time

    Job Openings MS SQL DBA + Developer (L3) Experience 9-11 Years Location Gurugram Job Summary: We are looking for a highly skilled MS SQL DBA + Developer (L3)  who is independent, proactive, and capable of guiding stakeholders in projects. The ideal candidate should be well-versed in database optimization, performance tuning, automation, security, and...

  • Dba

    2 weeks ago

    Gurugram, Haryana, India Akhil Systems Full time

    **Designation**: DBA **Job Location**: Gurugram, Udyog Vihar Phase 4 **Job Purpose**: As a Database Administrator (DBA), you will play a critical role in ensuring the reliability, security, and performance of our databases. You will work closely with clients and cross-functional teams to design, implement, and maintain database systems that support our...

  • Postgres Dba

    2 weeks ago

    Gurugram, Haryana, India Realign LLC Full time

    **Job Type: Full Time**: **Job Category: IT**: Job Title: Postgres DBA (Database Administrator) Job Summary: Responsibilities and Duties: - Install, configure, and maintain Postgres database systems. - Monitor database performance and optimize as needed. - Ensure database security and data integrity. - Backup and restore databases as needed. - Troubleshoot...

  • DBA Administrator

    3 weeks ago

    Gurugram, India Infogain Full time

    DBA Administrator (Senior) with skills Database Administrator, Microsoft SSIS, SQL Server DBA for location Gurugram, India Posted on: December 14, Share on Linkedin Share on Twitter Share on Facebook ROLES & RESPONSIBILITIES Job Role: MSSQL DBA | 10+ years Position Summary:  looking for a qualified MSSQL DBA L3 with 10+ years’ experience of working for...

  • Dba Administrator

    4 days ago

    Gurugram, Haryana, India Invokhr Full time

    **Job description** **Must-Have**: - Experience including database and server management. - Know-how of cluster management areas, such as adding/ bootstrapping/ removing nodes, consistency tuning, replication, and multi-DC configuration; - Experience and knowledge of monitoring, management, capacity planning and compaction strategy - Experience in database...

  • Database Administrator

    8 hours ago

    Gurugram, Haryana, India Akhil Systems Full time

    **Designation**: Database Administrator (DBA) **Job Location**: Gurugram, Udyog Vihar Phase 4 **Job Purpose**: **Responsibilities**: - **Database Management**: Install, configure, and upgrade database systems, including but not limited to MySQL, PostgreSQL, Oracle, SQL Server, or NoSQL databases. - **Monitoring & Optimization**: Monitor database...

  • NoSQL Dba

    8 hours ago

    Gurugram, Haryana, India FabHr Solution Pvt. Ltd. Full time

    **Job Description (Job Summary/Roles & Responsibilities)** - 24/7 Support handling L1 & L2 tickets - Installed and configured multi-nodes fully distributed Cassandra cluster. - Involved in Cassandra Cluster environment administration that includes adding and removing cluster nodes, cluster capacity planning, performance tuning, cluster Monitoring,...

  • Cloud Dba

    2 weeks ago

    Gurugram, Haryana, India RevInfotech Full time

    **Job description** **Cloud DBA having 4 + years plus experience Bangalore** Participate in requirements analysis Collaborate with internal teams.Develop documentation throughout the software development life cycle (SDLC) **Requirements and skills** Proven experience as Cloud DBA. Familiarity with the frameworks, design/architectural patterns (e.g....

  • Data Modeller

    4 days ago

    Gurugram, Haryana, India Rackspace Full time

    **Location**:Bangalore **Job Type**: Full-Time **Key Responsibilities**: - Analyze and translate business needs into data models. - Develop conceptual, logical, and physical data models to support business processes. - Has experience in building data models for core domains: Customer Master data, Claims, Underwriting, Actuary, Customer Complains/support...