Smith Arnold Partners
SQL DBA/Developer opportunity with one of the leading Financial Private Lender institutions. Exciting opportunity for a SQL DBA who also has experience developing queries and stored procedures to help build out this organizations Data Warehouse environment! Very stable environment that offers many opportunities for growth!
Very nice people. Good training and support for new employees. Flexibility. Great work life balance.
A valuable experience with a professional and friendly atmosphere
Title: SQL Database Administrator
Salary: 85,000 – 95,000
Location: Westport, CT
Exciting Database Administration/Developer opportunity responsible for managing application databases, build out a new data warehousing function, and perform customized querying and reporting across this organizations corporate data.
Responsible for database administration for MS SQL Server databases for various corporate applications including the lease portfolio management system and the general ledger system.
Primary responsibility for corporate data warehouse including building dimension and fact tables, implementing and managing ETL processes, and data tuning and optimization.
Perform installations, backups, restores, configuration, patching, tuning, and monitoring of application databases.
Support application developers with appropriate database access, scripts, and indexes.
Support ongoing data cleansing by implementing automated data checking, monitoring, and reporting
Maintain documentation including administrative operation processes, data dictionaries, data maps, data transformations, and data taxonomies
Ensure data security across all corporate data stores including identification and protection of personally identifiable information (PII).
Support management reporting needs by creating data extracts, writing specialized queries, and utilizing various reporting tools.
Five or more years of database administration experience in a MS SQL Server environment
Experience writing SQL queries and stored procedures
Experience with SQL Server Integration Services (SSIS)
Data Warehousing experience is a plus
Any expose to Azure DB experience is a plus
Bachelor’s degree or equivalent training and work experience