SQL Architect

21 hours 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.

  • SQL Architect

    4 days ago

    Bengaluru, Karnataka, India Infogain Full time ₹ 8,00,000 - ₹ 25,00,000 per year

    As a SQL Architect, your primary responsibility will be to design and implement database structures that meet the specific requirements of the organization. Your deep understanding of database technologies and experience in performance tuning will be essential as you work closely with stakeholders to translate business needs into technical solutions. Key...

  • SQL Architect

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

    1 week 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

    21 hours 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

    1 week 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...

  • Oracle Architect

    21 hours 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, Karnataka, India Black & White Business Solutions Full time

    **Job Information**: Industry **IT Services*** Province **Karnataka*** City **Bangalore North*** Postal Code **560001*** Country **India*** - Database Architect Engineer.- 1) Looking for DB/DW Architect(Datawarehouse /Database Architects) profiles please do share immediately.- Skills: DB/DW, AWS RDS with Redshift, ETL,MYSQL/Postgres. SSIS,SQL & BI...

  • Database Architect

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

  • Solution Architect

    21 hours ago

    Bengaluru, Karnataka, India BirlaSoft Full time

    Country/Region: IN- Requisition ID: 17778- Work Model: - Position Type: - Salary Range: - Location: INDIA - BENGALURU - BAXTER**Title**:Solution Architect**: - Description: - Job Description: Job Title: Solutions Architect Job Title: Solutions Architect - Baxter Healthcare (Remote location ) any where from India. Job Summary: Top 3 mandatory skills are...

  • PL/SQL Developer

    7 days ago

    Bengaluru, Karnataka, India, Karnataka Innover Digital Full time

    We are looking for an experienced PL/SQL Developer to join our team for a Sybase IQ to SQL Server migration project. The ideal candidate will have deep expertise in database development, data migration, and performance tuning, with proven experience converting complex Sybase stored procedures, triggers, and functions into SQL Server (T-SQL) equivalents.Key...