SQL DBA

---

Job description

Skills

At least 3 to 6 years of experience as an SQL Database Administrator in a Windows Server environment 2008, 2012, 2014, 2016 or 2019.

Education in SQL Database Administration.

Knowledge and experience with application software tools and application development methodology through complete life cycles. - preferred

Knowledge and experience with the following system software; database management, SQL scripting/programming and operating systems:

oSQL Database - must have, current knowledge and training

oWindows Server OS, functions/commands - must have

oSQL Management Studio - must have

oSQL - must have

oSQL scripting and modifications of files generated out of the DB - must have

oExtensive knowledge of T-SQL (Stored Procedures, Triggers, Indexing, Agents), Data Tuning and cleansing, Query Tuning, and Database Security - must have

oVisual Studio - preferred

oWebSphere Application Server - optional.

Ability to deal effectively with the information technology needs of: IT technicians and development staff; business users; and software vendor and management staff. - Strongly preferred

Good organization and workload management skills. - Strongly preferred

Effective written and oral communication skills and ability to establish and maintain good rapport with agency staff for effective and timely problem identification, resolution, and work efforts. - Strongly preferred.

Capability to work independently and effectively in complex environments.

Access DB experience - optional.

Education required:

Education in SQL database administration in support of a Mainframe. Provide documentation showing completed courses.

Brief Description of Job Duties:

This position is within the Tools and DBA section of Application Management and will be required to extract data and create reports to address legal questions in conjunction with discovery efforts associated with ongoing legal investigation.

Work with our legal analysts in providing data/analysis to adequately address submitted requests in a manner that is meaningful and relative to the legal questions asked. Format and present in a user-friendly format.

Consults with programmer/system analysts, peers, business users, outside agencies, third parties and vendors on issues related to the database and application software and if needed, presents written and oral solution and analyses. The procedure to resolve will vary based on the issue/question raised.

Convert or transfer database files or tables from existing storage locations and formats to replacement locations and formats; develop and test automated means for performing conversion to assign reports.

Ensure software and application documentation is prepared and updated this assigned projects, problem reports, work efforts and service requests.

Analyze content and quality of databases, recommend data management procedures, and develops extraction processes.

Identify opportunities for process improvement and automation.

Work closely with cross-functional teams to understand their data needs and provide support.

Other duties as assigned.

• Only those lawfully authorized to work in the designated country associated with the position will be considered.

• Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.

Benefits:

For information and details on employment benefits offered with this position, please visit here . Should you have any questions/concerns, please contact our HR Department via our secure website .

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here .

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department .

Rose International has an official agreement (ID ), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).

<!– job description page –>