What are the responsibilities and job description for the Database Developer (contract) position at KPMG US?
Title: SQL Developer/DBA
Job Description
KPMG complies with all local/state regulations in regard to displaying pay rate ranges. The pay rate range(s) displayed is/are specifically for those contracted who will perform work in or reside in the location(s) listed, if selected for the role. Pay is determined based on a variety of factors including market data, ranges, applicant's skills and prior relevant experience, certain degrees and certifications (e.g. JD, technology), and specific location, for example. Additionally, applicants may be required to apply and become employed by a service provider utilized by KPMG, and final pay rate(s) and/or eligibility for additional benefits may be determined by such provider.
KPMG LLP, its subsidiaries, and its agency service providers (including, but not limited to, MBO Partners Inc., Magnit LLC, and TalentBurst Inc.) are equal opportunity employers/contractors. All qualified applicants are considered without regard to race, color, creed, religion, age, sex/gender, national origin, ancestry, citizenship status, marital status, sexual orientation, gender identity or expression, disability, physical or mental handicap unrelated to ability, pregnancy, veteran status, unfavorable discharge from military service, genetic information, or other legally protected status.
Los Angeles County applicants: Material job duties for this position are listed above. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness, and safeguard business operations and company reputation. Pursuant to the California Fair Chance Act, Los Angeles County Fair Chance Ordinance for Employers, Fair Chance Initiative for Hiring Ordinance, and San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Pay Rate Range
Min Pay Rate Max Pay Rate Currency Unit 64 84 USD hourly
Job Description
- Design and implement robust data models to support application and business requirements, ensuring scalability and efficiency.
- Define and maintain database schemas, ensuring proper structure and adherence to best practices.
- Develop and optimize indexing strategies to enhance query performance and database efficiency.
- Manage data ingestion processes, ensuring seamless integration of data from various sources into the database.
- Oversee data export processes to support reporting, analytics, and external system integration needs.
- Act as the primary owner of all database systems, ensuring their reliability, security, and performance.
- Review and validate database-related work committed by other team members to ensure quality, consistency, and adherence to standards.
- Provide mentorship and guidance to team members on database design, development, and optimization practices.
- Establish and enforce database governance policies, including naming conventions, documentation, and access controls.
- Monitor and analyze database performance, identifying and addressing bottlenecks or issues proactively.
- Design, develop, and maintain complex SQL stored procedures to support application development and data processing.
- Perform performance tuning and optimization of SQL queries and databases to ensure efficient data retrieval and processing.
- Integrate with Azure Data Lake Storage (ADLS) for seamless data storage and retrieval.
- Manage and maintain Azure SQL databases, ensuring high availability and security.
- Implement data lake integration strategies to support data analytics and reporting needs.
- Develop and manage Azure Data Factory (ADF) pipelines for data movement and transformation.
- Oversee database management and sharding concepts to ensure scalability and performance.
- Utilize SQL dacpac projects for streamlined database deployment and version control.
- Manage deployment pipelines using Azure DevOps, ensuring smooth and efficient release processes.
- Coordinate and manage production deployments, providing support and troubleshooting as needed.
- Collaborate with cross-functional teams in an agile development environment to deliver high-quality solutions.
- Provide ongoing support and maintenance for database systems, addressing issues and implementing improvements.
- Stay updated with the latest industry trends and best practices in database management and cloud technologies.
- Act with integrity, professionalism, and personal responsibility to uphold the firm’s respectful and courteous work environment.
- Proven experience as a SQL Developer/DBA with expertise in stored procedures and performance tuning.
- Strong knowledge of Azure SQL, ADLS, and data lake integration.
- Experience with Azure Data Factory and pipeline management.
- Familiarity with database sharding concepts and practices.
- Proficiency in using SQL dacpac projects for database deployment.
- Experience with Azure DevOps for managing deployment pipelines.
- Strong problem-solving skills and attention to detail.
- Excellent communication and collaboration skills in an agile development setting.
- Ability to manage multiple tasks and projects simultaneously, meeting deadlines and ensuring quality.
- Any Microsoft Azure certification is a plus.
KPMG complies with all local/state regulations in regard to displaying pay rate ranges. The pay rate range(s) displayed is/are specifically for those contracted who will perform work in or reside in the location(s) listed, if selected for the role. Pay is determined based on a variety of factors including market data, ranges, applicant's skills and prior relevant experience, certain degrees and certifications (e.g. JD, technology), and specific location, for example. Additionally, applicants may be required to apply and become employed by a service provider utilized by KPMG, and final pay rate(s) and/or eligibility for additional benefits may be determined by such provider.
KPMG LLP, its subsidiaries, and its agency service providers (including, but not limited to, MBO Partners Inc., Magnit LLC, and TalentBurst Inc.) are equal opportunity employers/contractors. All qualified applicants are considered without regard to race, color, creed, religion, age, sex/gender, national origin, ancestry, citizenship status, marital status, sexual orientation, gender identity or expression, disability, physical or mental handicap unrelated to ability, pregnancy, veteran status, unfavorable discharge from military service, genetic information, or other legally protected status.
Los Angeles County applicants: Material job duties for this position are listed above. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness, and safeguard business operations and company reputation. Pursuant to the California Fair Chance Act, Los Angeles County Fair Chance Ordinance for Employers, Fair Chance Initiative for Hiring Ordinance, and San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Pay Rate Range
Min Pay Rate Max Pay Rate Currency Unit 64 84 USD hourly