Data Analyst (Nearby Candidates to MD)

Job Title: Data Analyst

Location: Baltimore MD

Job Type: Long-Term Contract

Client: Direct Client

Degree Certificates are mandatory to Submit.

Duties:

• Provide technical expertise and support in the use of DBMS.
• Design and implement automation of SQL Server Installation using scripts. Define file organization, indexing methods, and security procedures for specific user applications.
• Create and maintain database objects such as tables, views, indexes, constraints, etc. for data platforms and custom applications.
• Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensure that data integrity, security, and recoverability are built into the DBMS applications.
• Evaluate and recommend available DBMS products to support validated user requirements.
• Ensuring optimal database performance through exhaustive proactive testing and ongoing real-time monitoring.
• Monitor and maintain the backups for database recoverability for all production databases.

Education Qualification:

• Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.

General Experience:

• At least five (5) years of experience in administering on-prem/cloud based multi user environments with expertise in planning, designing, building, and implementing complex database systems.
• In-depth knowledge of the MS SQL Server DB architecture.
• Prior AWS cloud-based SQL Servers database administration experience.
• Drive end-to-end availability, performance monitoring, and capacity planning for MS SQL server, using native and 3rd party tools.
• Implemented industry best practices for consistent installation and configuration of MS SQL Server for production, pre-production, and non-production environments.
• Conducted technical reviews and walkthroughs of system design documentation with development and design team members.
• Experienced with MS SQL Server database administration throughout the nonproduction (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment.
• Testing database security and enterprise policy guidelines according to established best practices.
• Must be proficient in scripting.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.