Database architect serp_jobs.h1.location_city

Job Description

Job Description

Description :

Overall Accountability

Monitor, maintain and provide operational support for databases servers. Provide support in the administration, backup, integrity and security of various SQL databases. Work with Sr DBA to maintain high performance of database systems, resources and storage. Monitor and maintain database maintenance plans. Apply database service packs and cumulative updates. Maintain database documentation. Follow Change Management processes to implement database configuration changes. Follow Problem Management processes to troubleshoot and resolve recurring issues. Proactively monitor and respond to MSSQL database Alerts. Provide production support of databases, SQL server agent jobs, and SSRS reports. Write and maintain PowerShell scripts for automated SQL server agent jobs. Troubleshoot and resolve any issues with automation. Maintain source control for database objects including development / test database servers. Produces and maintains quality documentation on database structures and procedures. Available on-call for production support after business hours.

Position Required Qualifications

Minimum Education and Experience

Bachelor’s degree in computer science, engineering or related field and 2 years’ experience in database development, maintenance, or a combination of education and experience. One year technical experience with SQL server, SSIS, PowerShell Scripts and Transactional SQL. (Stored procedures, Triggers and Functions).

Knowledge, Skills, and Abilities

Knowledge of data visualization tool Tableau. Knowledge of index tuning strategies, performance tuning, database partitioning and query optimization in MS SQL Server. Knowledge of data warehousing, ETL and proprietary and / or structured or open relational SQL databases. Demonstrated problem-solving skills. Excellent verbal and written communication skills. Ability to multi-task with attention to detail, manage time efficiently and evaluate / prioritize, as a necessary. Ability to troubleshoot problems as they occur and work in a team environment.

Licenses, Training, and Certifications Required

None

Preferred Qualifications

Financial products industry experience.

Hybrid Work Environment and Physical Demands

• Frequently required to stand, walk, stoop, kneel or crouch.
• Frequently required to sit.
• Regularly required to use hands to finger keys accurately when computer keyboards; reach with hands and arms.
• Occasionally lift and / or move up to 25 pounds.
• Specific vision abilities required by this job include close vision, ability to adjust focus.
• The noise level in the home office work environment is usually moderate; however, this position entails mostly remote work.

NOTE : The job description is intended to be generic in nature. It is not an exhaustive list of all duties and responsibilities. Requirements listed in the above qualifications and physical requirements are representative of the knowledge, skill, abilities, physical demands, or work environment required or encountered that must be met by an employee to successfully perform each duty and each function of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

Employees who work from home must have business operational internet to complete work tasks and communicate via video call or chat messaging systems in a dedicated workspace.

Requirements :