Microsoft SQL Server 2019 Teamware Solutions

3.0 - 5.0 years

2 - 5 Lacs

Bengaluru, Karnataka, India

On-site

Key Responsibilities: Database Management: Administer, configure, and manage Microsoft SQL Server 2019 environments. Ensure high availability and disaster recovery planning, using technologies such as Always On Availability Groups , SQL Server Clustering , and Database Mirroring . Perform regular database backups , restores , and replications to ensure data integrity and availability. Manage SQL Server security , including permissions , roles , and encryption . Database Development: Design, develop, and maintain SQL Server 2019 databases and SQL queries to support business applications. Optimize SQL queries for performance, ensuring minimal query execution time and optimal resource utilization. Create and maintain stored procedures , views , functions , and triggers for business logic implementation. Assist in data migration tasks and ensure smooth integration of SQL Server 2019 with other business systems and applications. Performance Tuning and Optimization: Monitor SQL Server performance using built-in tools such as SQL Server Management Studio (SSMS) , SQL Profiler , and Dynamic Management Views (DMVs) . Identify and resolve performance bottlenecks, including index optimization , query tuning , and server configurations . Implement and manage indexes , statistics , and partitioning to ensure optimal query performance. Backup and Recovery: Implement and manage backup and restore strategies to ensure data integrity and availability in case of system failures. Configure and test disaster recovery plans, ensuring minimal downtime and data loss. Ensure automated backup processes are in place and validated regularly. Security and Compliance: Implement SQL Server security best practices, including role-based access control , encryption , and auditing . Ensure compliance with industry standards and regulatory requirements related to data management and privacy. Maintain database audit trails , ensuring all changes and accesses are properly logged and monitored. Troubleshooting and Support: Provide technical support and troubleshooting for SQL Server 2019 issues, ensuring the stability and performance of the databases. Investigate and resolve database-related issues, including performance issues , corruption , and data inconsistencies . Collaborate with development and IT teams to resolve application issues related to the database. Documentation and Reporting: Maintain accurate and up-to-date documentation on database configurations, maintenance procedures, and recovery plans. Generate reports on database performance, resource utilization, and potential risks. Assist in capacity planning and forecasting resource needs for the databases based on growth projections. Collaboration and Stakeholder Engagement: Collaborate with cross-functional teams, including development , operations , and business analysts , to gather requirements and deliver database solutions. Provide support for data migration , ETL processes , and integrations with other systems. Train and mentor junior database administrators and developers on best practices for database management and development. Required Qualifications: Bachelor's degree in Computer Science , Information Technology , Software Engineering , or a related field. 3-5 years of experience in Microsoft SQL Server , with strong experience in SQL Server 2019 . Solid understanding of database administration , including backup/recovery , performance tuning , high availability , and disaster recovery . Proficiency in SQL development , including writing T-SQL queries , stored procedures , functions , triggers , and views . Experience with SQL Server Management Studio (SSMS) , SQL Profiler , and other SQL Server administration tools. Strong understanding of security , permissions , and encryption practices within SQL Server . Knowledge of indexing strategies, query optimization , and database partitioning . Experience with PowerShell scripting for database automation and management is a plus. Familiarity with cloud-based SQL environments (e.g., Azure SQL Database ) is a plus.

Posted 2 days ago

Apply

Power BI Developer Vayuz Technologies

12.0 - 15.0 years

5 - 9 Lacs

Kanpur

Remote

Role Expectations : - Design, develop, and maintain interactive dashboards and reports using Power BI. - Create and optimize data models, including star/snowflake schemas. - Develop complex DAX calculations and KPIs to drive business insights. - Integrate data from various sources (SQL Server, Excel, SharePoint, APIs, etc.) - Collaborate with business stakeholders to gather requirements and translate them into technical solutions. - Perform data validation and troubleshooting to ensure accuracy and performance. - Implement row-level security and user-based data access strategies. - Provide guidance on Power BI governance, best practices, and self-service analytics models. - Maintain data refresh schedules and monitor report performance. - Work with cross-functional teams including data engineers, analysts, and business users. Qualifications : - 12+ years of hands-on Power BI development. - Advanced DAX and data modeling expertise. - Experience with Power Query/M Language. - Strong dashboard and visualization design skills. - Power BI Service and Power BI Report Server knowledge. - Row-level security and gateway configurations. - Familiarity with Power BI REST API and embedding techniques. - Proficient in writing complex T-SQL queries, stored procedures, views, and functions. - Data extraction, transformation, and integration using SQL. - Experience with large datasets and performance tuning.

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