SQL / Azure DBA (Data Security Project)

About GSPANN
Headquartered in Milpitas, California (U.S.A.), GSPANN provides consulting and IT services to global clients, ranging from mid-size to Fortune 500 companies. With our experience in retail, high-technology, and manufacturing, we help our clients to transform and deliver business value by optimizing their IT capabilities, practices, and operations. Counting on our ten offices, including four global delivery centers, and approximately 1400 employees globally, we offer the intimacy of a boutique consultancy with capabilities of a large IT services firm.

Database Administrator/Data Security Engineer
Location-Fremont , CA
Job Type-Long Term
Job Title:
The DBA/Data Security Engineer will have a strong background in securing and maintaining an enterprise cloud data environment.
Preference will also be given to Cloud Security Engineers or Database Administrators (DBAs) with experience in Analytics Data Security.

Responsibilities: (this is not an all-inclusive list; duties may evolve over time as business needs change)

• Strong communication and collaboration skills to work effectively with cross-functional teams
• Implement and maintain cloud data and analytics security solutions
• Implement access policies to secure databases, schemas, tables, and other database objects
• Implement access policies to secure CCI and PII sensitive data using Row-Level Security (RLS), Column-Level Security (CLS), data masking, and data encryption features
• Understand and abide by all Information Security policies and control standards
• Conducts troubleshooting of data security issues, performs root cause analysis and optimize security incidents through lessons learned process
• Adept understanding of the Cloud Security best practices in Azure
• Proven experience with Microsoft technologies including Azure B2B and Application Security in Azure

Education / Experience

• Bachelor's Degree in Computer Science, Information Technology, Information Security, Information Assurance, Information Management in related field or equivalent experience
• Certifications in Cloud Cybersecurity (e.g., CCSP, CCSK, Microsoft Azure Security Engineer Associate (AZ-500), etc.) Strongly Preferred

Knowledge / Skills / Abilities

• Excellent problem-solving skills and the ability to perform root cause analysis.
• 7 years of experience working in Database Administration/Data security Engineering
• 2-3 years of experience in Azure data warehousing and analytics stack with a focus on data security set up

• 3 years of experience in SQL DB/Warehouse security setup and implementing access policies to secure CCI and PII sensitive data using Row-Level Security (RLS), Column-Level Security (CLS), data masking, and data encryption features
• Must have at least 3 years' experience with SQL database development in creating complex queries, optimization and maintaining existing queries,

• 3 years of experience in working with Microsoft Azure and strong knowledge about ADLS, Blob Storage, Data Factory, SQL WH etc.
• Familiarity with common APIs: REST, SOAP preferred

Working at GSPANN GSPANN is a diverse, prosperous, and rewarding place to work. We provide competitive benefits, educational assistance, and career growth opportunities to our employees. Every employee is valued for their talent and contribution. Working with us will give you an opportunity to work globally with some of the best brands in the industry. The company does and will take an affirmative action to employ and advance in the employment of individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability status. GSPANN is an equal opportunity employer for minorities/females/veterans/disability.