Senior SQL Data Architect & Cloud Migration Lead

Pyramid Consulting; Los Angeles (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

A leading tech consulting firm is seeking a Senior SQL Server Database Engineer to manage and optimize enterprise data systems. Responsibilities include overseeing database design and implementation, ensuring data integrity, and leading migrations to cloud environments. The ideal candidate has a Bachelor's degree, relevant Microsoft certifications, and advanced skills in SQL Server and cloud technologies. This position offers a chance to work on critical infrastructure projects and play a key role in technical leadership.

Qualifications

• Must have advanced experience in database administration, including performance tuning and environment availability.
• Expert-level knowledge of Microsoft SQL Server High Availability and Advanced Diagnostic Tools required.
• Experience with both physical and cloud instances of SQL Azure is necessary.

Responsibilities

• Responsible for database design, implementation, maintenance, and management.
• Oversees company data management systems including data exchange and security.
• Leads migration of on-premises SQL to cloud environments.

Skills

Database administration

Microsoft SQL Server

Cloud technologies

Performance tuning

Disaster recovery planning

NoSQL technologies

Technical leadership

Education

Bachelor’s Degree or equivalent

Microsoft Certification

Tools

SQL Server 2008/2012/2014/2016

Windows Server 2008/2012

SQL Azure

Cassandra

MongoDB

Job description

· The Senior SQL Server Database Engineer is responsible for the database design, implementation, maintenance, and management of the Enterprise data system.

· He/She provides leadership in technical infrastructure planning, guidance to staff on database systems and technical issues, and mentors team members in best practices.

· This position directs component and data architecture design, technology planning, and testing for Applications Development initiatives to meet business requirements and ensure compliance.

· He/She researches, supports, and leads the integration of cloud technologies.

· This position leads team members with project related activities and tasks.

Job Duties:

· Manages and maintains company data management systems (e.g., operational data stores [relational and non-relational], Data Warehouse, Reporting, etc.), to encompass design, installation, deployment, backup, restoration, optimization, security, and data exchange.

· Develops logical and physical architecture models.

· Manages administration and database performance by tuning file structures and managing indexes.

· Partners with Software Architects and Software Engineers on data access methods and decisions on optimal data structures for persistence.

· Safeguards data integrity and maintains security controls in all existing databases and data exchange technology through process, training, quality control, and monitoring.

· Writes simple to complex SQL queries, troubleshoots queries, and tunes queries for best performance.

· Designs and implements processes to automate transactional information functions in search of maximum operational efficiency throughout the organization.

· Manages data operations for data at rest, data exchange, batch processing, and data reporting.

· Supports development and production activities.

· Generates and maintains documentation of data store architectures, configurations, operations, and maintenance.

· Evaluates Microsoft technology, hot fixes, upgrades, and version releases to ensure architecture stability.

· Configures and manages Microsoft's Windows Server 2008/2012, and SQL Server 2008/2012/2014/2016, demonstrating how these technologies may be leveraged to impact the architecture's overall design, security, availability and stability.

· Leads the migration of on-premises SQL Instances into a cloud environment.

· Must have a Bachelor’s Degree (or internationally comparable degree) or be a current UPS employee with three years of UPS experience

· Must have Microsoft Certification (e.g., Microsoft Certified Solutions Associate, Microsoft Certified Solutions Expert, Microsoft Certified Database Administrator, etc.)

· Must have advanced experience in database administration (e.g., performance tuning, environment availability, and capacity planning)

· Must have expert-level knowledge of Microsoft SQL Server High Availability, Replication, Scalability, and Advanced SQL Server Diagnostic and Tuning Tools

· Must have experience deploying physical and cloud instances of SQL Azure

· Must have experience demonstrating proficiency in at least on noSQL Database technology (e.g., Cassandra, MongoDB, etc.)

· Applies Disaster Recovery Knowledge: Creates disaster recovery plans for own environment and helps document procedures; plans and tests recovery procedures in a remote backup environment.

· Applies Foundation Architecture Knowledge: Demonstrates knowledge of the existence of foundation architecture standards; supports the need to adhere to standards; knows who to ask for information and guidance.

Additional Information

All your information will be kept confidential according to EEO guidelines.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply