• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 5th Apr 2024

·       Define and enforce database standards and policies, including schema design, indexing, and naming conventions.

·       Collaborate with development teams to optimize database design, creation, and testing, ensuring efficient data storage and retrieval.

·       Implement high-availability solutions such as clustering and replication.

·       Utilize performance monitoring tools to identify and address bottlenecks and performance issues.

·       Optimize tables, indexes, and queries to achieve peak database performance.

·       Manage database partitions and filegroups for efficient data storage.

·       Develop and implement event triggers using SQL Server Agent for proactive monitoring of database performance and integrity.

·       Execute regular maintenance tasks, including database tuning, query optimization, and index rebuilding.

·       Implement data compression and archiving strategies for effective data management.

·       Utilize SQL Server Profiler and Extended Events to monitor usage, transaction volumes, response times, and concurrency levels.

·       Analyze and optimize execution plans for resource-intensive queries.

·       Implement role-based security models and conduct regular security audits.

·       Manage encryption for sensitive data and maintain compliance with security standards.

·       Configure and maintain regular database backups and implement recovery procedures.

·       Optimize storage allocation and implement storage tiering strategies.

Additional Skills (Icing on the Cake):

·       Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) for data integration.