SQL Architect

6 days ago

Bengaluru Karnataka, India BirlaSoft Full time

Country/Region: IN- Requisition ID: 10589- Work Model:
- Position Type:
- Salary Range:
- Location: INDIA - BENGALURU - BIRLASOFT OFFICE**Title**:SQL Architect**:

- Description:

- **SQL Server DBA Architect**

**Mumbai/Pune/Noida/Bangalore**

**12-15 Years**
- Check to make sure the SQL Server is online, and connectivity is working fine.
- Check error logs and if found any critical errors then escalate to L2 DBA
- Ensure all (Full, differential and log) backups are running fine.
- Check open tickets/issues and be sure issues/requests are addressed within SLA.
- Ensure that no SQL Server job has failed and follow the SOPs if any job is failing.
- Check the general health of the server (space, CPU utilization, memory) to confirm there are no issues.
- Acknowledge every mail within SLA and if required escalate to L2 DBA.
- Join bridge calls for P1(SEV1) and P2 (SEV2) incidents along with L2/L3 DBAs.
- Make sure to respond to all the SQL DB alerts and take proper action.
- Work on DB Refresh activity
- Installation/Upgradation/Migration of SQL Servers.
- Configure High Availability/Disaster recovery solutions.
- Configure automated alerts to send a mail to team if any issues.
- Work on incidents, change tickets and problem tickets.
- Setup Maintenance plans for Backups, Database integrity check, rebuild index and Update statistics and make sure to run all the jobs without any issues.
- Troubleshoot locking issues, including deadlocks, blocking, lock timeouts and fix them.
- Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
- Execute all changes of DB schema and maintain controlled development database environment.
- Handle database object deployment to Integration, QA, UAT, and Production
- Provide day to day support of high OLTP HA of SQL Server databases
- Identify root causes of production problems and work with developers to resolve such problems.
- Work on performance tuning like creating missing indexes.
- Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
- Attend CAB (Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
- Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
- Work on Writing custom stored procedures, t-SQL queries, PowerShell scripts, views, and triggers based on requirements for DB maintenance and automate tasks.
- Work on writing technical and RCA (Root Cause Analysis) documentation.
- Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
- work on performance tuning like provide suggestions to create indexes and tune stored procedures.
- Troubleshoot recurring problems and fix them permanently.
- Conduct DB DR Drill activity, ensure to bring the DR site online if any outage at Primary site.

  • Architect - SQL

    6 days ago

    Bengaluru, Karnataka, India Philips Full time

    **Job Title**:Architect - SQL **You are responsible for** - Software Architect is responsible for finalizing the design of user stories, ensuring they align with the overall architecture and development goals, and takes part in code reviews and maintaining code quality. - The role focuses on component integration and functionality, optimizing system...

  • SQL Architect

    2 weeks ago

    Bengaluru, India SA Technologies Inc. Full time

    Shift time - 2nd YOE- 13-16 years **SQL DB Architect Required Skills and JD (onsite/offshore)**: - A strong **SQL** **DB **track record and expert knowledge of **Microsoft **SQL server including SQL 2005/2008/2012/2016/2019 - Should have knowledge on Microsoft architecture as well to understand MSO - Design databases to for business solutions,...

  • SQL Architect

    2 weeks ago

    Bengaluru, Karnataka, India Virtusa Full time

    Demonstrable experience in database design and development role on medium to large, enterprise-scale databases. The engineer must be familiar or have experience with Enterprise Integration Patterns, EAI, SOA, EDA architectures and their main principles 12+ years of experience in database development. Working with RDBMS and NoSQL databases. PostgreSQL /...

  • SQL Dba Architect

    6 days ago

    Bengaluru, Karnataka, India UST Global Full time

    9 - 12 Years - 1 Opening - Bangalore **Role description**: **Key Responsibilities**: - **SQL Server Installation & Configuration**: Install, configure, and maintain SQL Server instances and databases to ensure their smooth operation. - **Performance Monitoring & Troubleshooting**: Continuously monitor SQL Server performance, identify potential issues, and...

  • Architect

    2 weeks ago

    Bengaluru, Karnataka, India BirlaSoft Full time

    Country/Region: IN - Requisition ID: 25484 - Work Model: - Position Type: - Salary Range: - Location: INDIA - BENGALURU - BIRLASOFT OFFICE **Title**:Architect**: - Description: **Area(s) of responsibility**: Experience in EDQ, Integration development preferred. Oracle SQL DB, PL/SQL a must. Knowledge on Oracle PHC Extensive experience with Oracle...

  • Associate Architect

    1 week ago

    Bengaluru, Karnataka, India Arting Digital Private Limited Full time

    **Posting title**: Associate Architect **Experience**: 8-20 Years **Location**: Bangalore **Work mode**: On-site **primary skills**:.NetCore, Angular, SQL, Azure Cloud, Team lead, Architecting, Design Patterns **Qualification**: Any Engineering/ Computers degree **Roles & **Responsibilities**: - Understanding of.NET, C#, experience with.NET 4.0/4.5...

  • Oracle Architect

    6 days ago

    Bengaluru, Karnataka, India PradeepIT Consulting Services Full time

    **About the job Oracle Architect**: **Position**: Oracle PL/SQL Architect **Experience**: - Minimum 8+ years of experience in Oracle PL/SQL - At least 2 full life cycle implementation projects - Minimum 2+ years of experience as an Architect **Technical Skills**: - Strong problem-solving, analytical, and decision-making skills. - Proven experience in...

  • Database Architect

    2 weeks ago

    Bengaluru, India Prometheus consulting Full time

    Key Responsibilities :Database Architecture & Design :- Design, implement, and maintain enterprise-scale SQL Server database solutions- Develop database architecture standards, best practices, and design patterns- Lead database capacity planning and scalability initiatives- Architect high-availability and disaster recovery solutions using SQL Server Always...

  • Data Architect(Adf)

    1 week ago

    Bengaluru, Karnataka, India Prakhar Software Solutions Pvt Ltd Full time

    **We’re Hiring: Azure Data Factory Architect/Associate Architect** **Location**: HRBR Layout, Kalyan Nagar, Bangalore **Position Type**: Full-time, Permanent **Mode**: Work from Office **Notice Period**: 0 to 15 Days **Budget**: - **Associate Architect**: ₹16L - ₹20L - **Architect**: ₹25L - ₹28L **Role Overview**: We are looking for experienced...

  • Data Solutions Architect

    1 week ago

    Bengaluru, Karnataka, India Prakhar Software Solutions Pvt Ltd Full time

    **We Are Hiring: Data Architect** Are you passionate about designing and implementing data solutions? We’re looking for a skilled **Data Architect** with strong experience in SQL and Azure Data Factory (ADF) to join our team! **Position**: Data Architect **Experience**: 8+ years in SQL and 5+ years in ADF **Location**: Bangalore **Mode**: Full-time,...