6.0 - 10.0 years

0 Lacs

karnataka

On-site

You will be responsible for designing and implementing logical and physical data models to meet application requirements. This includes developing and maintaining relational database structures using SQL Server. You will create and optimize stored procedures, views, functions, and triggers to ensure data integrity, consistency, and scalability. Performance tuning, query optimization, and indexing strategies will be within your scope, along with analyzing execution plans and troubleshooting slow-running queries. Collaboration with developers, analysts, and DevOps teams is essential to deliver high-performing solutions. Furthermore, you will maintain and enhance existing database systems while adhering to best practices and security standards. To excel in this role, you should possess 6-10 years of hands-on experience with Microsoft SQL Server. A strong background in data modeling, including ER diagrams, normalization, and schema design, is required. You must have in-depth knowledge of T-SQL and database development best practices. Experience in database performance tuning, index design, and execution plan analysis is crucial. Proficiency in database design tools such as ER/Studio, ERwin, or Visio is expected, along with familiarity with version control and CI/CD practices for database changes. Desirable skills include experience with SSIS, SSRS, or Power BI, as well as exposure to cloud database platforms like Azure SQL or AWS RDS. Possessing Microsoft certifications in SQL Server technologies would be an added advantage.,

Posted 4 days ago

Apply

SQL Database Administrator Vensure Employer Solutions

6.0 - 10.0 years

0 Lacs

thiruvananthapuram, kerala

On-site

As a Database Administrator at our Trivandrum office (Work from office), you will be responsible for configuring and maintaining database servers and processes. Your role will involve monitoring system health and performance to ensure high levels of performance, availability, and security. Troubleshooting and resolving performance issues will also be a key part of your responsibilities. You will be involved in SQL Server performance tuning, which includes analyzing query execution plans, SQL server profiling, index design and tuning, as well as index maintenance strategies. Managing database backup and recovery processes will be crucial to ensure data integrity and availability. In addition to day-to-day tasks, you will also be expected to participate in database administration related projects as needed. Responding to critical and non-critical production alerts and being available on an on-call rotation schedule for providing production support during critical issues will be required. To be successful in this role, you should have 6-9 years of SQL Server experience, including 2+ years of SQL Server development experience and 4+ years in Database Administration. A Bachelor's degree in Computer Science or a related major is preferred. Experience with SQL Server 2016 and 2019 is required, along with familiarity with Azure. Your expertise should include writing SQL queries and stored procedures, optimizing queries and database objects, and advanced skills in index design and maintenance. Experience with SQL Server Service Broker, SQL Server in a Windows Cluster environment, and AlwaysOn Availability Groups is highly beneficial. Knowledge of encryption techniques such as TDE and Always Encrypted is also desirable. Proficiency in using monitoring tools like SQL Monitor, Zabbix, SolarWinds, Idera, and System Center will be advantageous. You should possess excellent problem-solving skills, effective research abilities, and the dedication to work alternative schedules when necessary. Strong verbal and written communication skills are essential for this role, along with self-motivation and the ability to work both independently and as part of a team. Experience in supporting enterprise-level production systems in a fast-paced, high availability server environment is preferred. Desired qualifications for this role include experience in PostgreSQL, which would be considered a plus.,

Posted 1 month ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.