SQL Dba Data Modeller

3 days 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

  • Database Administrator

    2 days ago

    Gurugram, Haryana, India Resolink Technologies Private Limited Full time

    **We are hiring for Database Administrator (DBA) - SQL & NoSQL** **Experience: 4+ years** **Qualification: Tech/M. Tech/MCA in Computer Science** **Job Location: Onsite, Gurugram** **Key Responsibilities**: **Manage SQL & NoSQL Databases: Administer MySQL, PostgreSQL, MongoDB, DynamoDB on cloud (AWS, Azure, GCP)** **. - Optimize Performance: Implement...

  • Database Administrator

    4 days ago

    Gurugram, Haryana, India Resolink Technologies Private Limited Full time

    **We are hiring for Database Administrator (DBA) - SQL & NoSQL** **Experience: 4+ years** **Qualification: Tech/M. Tech/MCA in Computer Science** **Job Location: Onsite, Gurugram** **Key Responsibilities**: **Manage SQL & NoSQL Databases: Administer MySQL, PostgreSQL, MongoDB, DynamoDB on cloud (AWS, Azure, GCP)** **. - Optimize Performance: Implement...

  • Data Modeller

    4 days ago

    Gurugram, Haryana, India Coforge Ltd. Full time

    **Title - Data Modeler** **Duration: Full Time** **Location: Gurugram/Gurgaon (WFO)** - Responsibilities - Data analysis to understand the data and relationship in source systems - Updating and optimizing local and metadata models - Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data...

  • SQL Database Administrator

    3 days ago

    Gurugram, Haryana, India Nexus pro services Full time

    Job Title**:Database Administrator (DBA)** Department: Technology & Data Science Location**:Gurugram** Level: [**5-8 Years**] Expected CTC: 15-16 Lakhs **Job Summary**: **Key Responsibilities**: - **Database Administration & Optimization**: - Manage and administer Microsoft SQL Server and MySQL databases. - Optimize stored procedures and queries for...

  • SQL

    4 days ago

    Gurugram, Haryana, India Virtusa Full time

    SQL Job expectation: Understand the data model / design and develop the ETL jobs Sound technical knowledge on Informatica to take ownership of allocated development activities in terms of working independently Working knowledge on Oracle database to take ownership of the underlying SQLs for the ETL jobs (under guidance of the technical leads) Providing the...

  • SQL Database Administrator

    4 days ago

    Gurugram, Haryana, India AHEAD Full time

    AHEAD builds platforms for digital business. By weaving together advances in cloud infrastructure, automation and analytics, and software delivery, we help enterprises deliver on the promise of digital transformation. At AHEAD, we prioritize creating a culture of belonging, where all perspectives and voices are represented, valued, respected, and heard. We...

  • Database Administrator

    2 days ago

    Gurugram, Haryana, India Brilliantech Software Full time

    Database Administrator (DBA) Company : (Payroll Position) Location: Gurugram (Onsite) **Job Type**: Contract - 6 Months Budget : Competitive salary package Experience : 5 to 7 years Notice Period : Immediate Joiners Preferred Job Description: Key Responsibilities: - Administer, monitor, and maintain PostgreSQL databases on production environments. -...

  • Model N Application Support Sme

    13 hours ago

    Gurugram, Haryana, India NTT DATA Full time

    **Req ID**: 245588 We are currently seeking a Model N Application Support SME to join our team in Bangalore, Karnātaka (IN-KA), India (IN). **ESSENTIAL SKILLS**: - Good experience working with Model N Revenue Cloud Powered by N product - Sound Knowledge of Chargebacks, Rebates, Contracts, Products, Customers, Membership modules - Experience with EDI...

  • Data Modeller

    2 days ago

    Gurugram, Haryana, India Rackspace Full time

    Overview About the Role As a Data Modeller, you will be responsible for designing and implementing data models for our Databricks-based Modern Data Platform. You will work closely with business stakeholders, data architects, and data engineers to create logical and physical data models that support the migration from legacy systems to the Databricks...

  • SQL Dba L1

    3 days ago

    Gurugram, Haryana, India Hexaware IT Full time

    Manage SQL Server databases - Configure and maintain database servers and processes - Monitor system's health and performance - Ensure high levels of performance, availability, sustainability and security - Analyze, solve, and correct issues in real time - Provide suggestions for solutions - Refine and automate regular processes, track issues, and document...