SQL Database Administrator

As an experienced SQL Server Database Administrator (DBA), your role will involve managing, maintaining, and optimizing the organization's database environments across production, QA, and development systems. Key Responsibilities: - Create and manage multiple databases, assist in capacity planning, and monitor database systems for proactive maintenance. - Troubleshoot issues, perform database housekeeping, and manage production, QA, and development database environments. - Utilize tools like SQL Server Profiler for database tuning, generate traces, review execution plans, and identify and resolve performance issues. - Set up and maintain database infrastructure supporting the company's BI requirements. - Maintain data integrity, security, and manage roles and permissions of database users. - Understand business processes, data flows, criticality, and system dependencies. - Develop strategies and implement solutions for database backup, restoration, and replication. - Document database infrastructure, incidents, resolutions, and client interactions. - Support software developers with database operations, tuning DML statements, and creating stored procedures. - Coordinate and communicate effectively with stakeholders, including internal teams and clients. Qualifications: - 8+ years of experience administering Microsoft SQL Server. - Strong knowledge of RDBMS concepts, database architecture, and SQL/T-SQL. - Extensive experience writing T-SQL, stored procedures, functions, triggers, and complex queries. - Experience supporting high-transaction databases. The role will involve working in a Microsoft SQL Server-centric data environment with a technology stack that includes: - Database Platform: Microsoft SQL Server - Query Language: T-SQL - Database Tools: SQL Server Management Studio (SSMS), SQL Server Profiler - Data Integration: SQL Server Integration Services (SSIS) - Reporting & Analytics: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) - Data Processing: ETL and data integration processes - High Availability: SQL Server clustering, log shipping, database mirroring, failover clustering, and replication technologies - Development Support: Stored procedures, triggers, functions, indexing strategies, and query optimization. As an experienced SQL Server Database Administrator (DBA), your role will involve managing, maintaining, and optimizing the organization's database environments across production, QA, and development systems. Key Responsibilities: - Create and manage multiple databases, assist in capacity planning, and monitor database systems for proactive maintenance. - Troubleshoot issues, perform database housekeeping, and manage production, QA, and development database environments. - Utilize tools like SQL Server Profiler for database tuning, generate traces, review execution plans, and identify and resolve performance issues. - Set up and maintain database infrastructure supporting the company's BI requirements. - Maintain data integrity, security, and manage roles and permissions of database users. - Understand business processes, data flows, criticality, and system dependencies. - Develop strategies and implement solutions for database backup, restoration, and replication. - Document database infrastructure, incidents, resolutions, and client interactions. - Support software developers with database operations, tuning DML statements, and creating stored procedures. - Coordinate and communicate effectively with stakeholders, including internal teams and clients. Qualifications: - 8+ years of experience administering Microsoft SQL Server. - Strong knowledge of RDBMS concepts, database architecture, and SQL/T-SQL. - Extensive experience writing T-SQL, stored procedures, functions, triggers, and complex queries. - Experience supporting high-transaction databases. The role will involve working in a Microsoft SQL Server-centric data environment with a technology stack that includes: - Database Platform: Microsoft SQL Server - Query Language: T-SQL - Database Tools: SQL Server Management Studio (SSMS), SQL Server Profiler - Data Integration: SQL Server Integration Services (SSIS) - Reporting & Analytics: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) - Data Processing: ETL and data integration processes - High Availability: SQL Server clustering, log shipping, database mirroring, failover clustering, and replication technologies - Development Support: Stored procedures, triggers, functions, indexing strategies, and query optimization.