Oracle Database Administrator Salary in New Jersey, USA

ResponsibilitiesOwnership in installations, creation, management, monitoring, scaling and tuning RDMBS and NoSQL databases for various business units.Day to day management activities of production databases for online system operations including monitoring, troubleshooting, backup, restore, change management, and storage managementDevelopment of stored procedures, packages, triggers, SQL queries, reports, forms and scripts.Responsible for Database Replay, Partitioning, DB Sharding, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security.Run performance and tuning tools such as ASH, AWR, and STATSPACK.Participate in discussions and recommend new strategies for installation, upgrade, configuration, and patching of new and existing RDBMS infrastructure (Oracle & MySql) and NoSQL infrastructure (MongoDB & Cassandra).Recommend new strategies and architectures for high availability, monitoring, database security, backup, and recovery for large scale databasesYou will be working with AWS RDS & Dynamo DB.Required Skills/ExperienceBachelor's degree in Computer Science or equivalent is preferred10+ years of DBA experience in RDMBS (Oracle, MySQL, PL/SQL).5+ years of experience in NoSQL such as Cassandra and MongoDBExpertise in JSON document modeling and data transformation (XML, JSON, CSV, RDBMS)Expertise in development of stored procedures, packages, triggers, SQL queries, reports, forms and scripts.Expertise in Database Replay, Partitioning, DB Sharding, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security.Good understanding of service (canonical) schema, forward and reverse model engineering, Data Flow DiagramingHands on experience with various performance and tuning tools such as ASH, AWR, STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF and ADDM reports.Strong background in Data Management Best Practices, Data Integration, Data Rationalization and Data PatternsStrong understanding in the principles of Data warehousing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.Scripting language skills such as Perl, Python, and Bash is a strong plusExperience in Hadoop Big Data environment (Hive, Pig, Map Reduce) is a big plusStrong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams

Center 2 (19050), United States of America, McLean, VirginiaPrincipal Associate, Database AdministratorDo you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital One, you'll be part of a big group of makers, breakers, doers and disruptors, who love to solve real problems and meet real customer needs. We are seeking a Database Administrators who are passionate about managing, marrying data with emerging technologies to join our team. As a Database Administrator, you'll have the opportunity to be on the forefront of driving a major transformation within Capital One.What You'll Do:Support Oracle Database Administration involving Data Guard, GoldenGate and migrations.Utilize programming languages like Python, Linux and Unix Shell scripting, SQL tuning with Open Source RDBMS and NoSQL databases working experience.Collaborate with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools, CI/CD deployment and technologies.Work with a team of developers with deep experience in machine learning, distributed microservices, and full stack systems.Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performanceShare your passion for staying on top of tech trends, experimenting with and learning new technologies, participating in internal & external technology communities, and mentoring other members of the engineering communityCollaborate with digital product managers, and deliver robust cloud-based solutions that drive powerful experiences to help millions of Americans achieve financial empowermentBasic Qualifications: Bachelor's DegreeAt least 4 years of experience with relational database technologies (Oracle, PostgreSQL, MySQL)At least 3 years of experience in system analysis and data managementAt least 3 years of experience managing Linux Server platformsAt least 2 years of experience with Cloud Native technologies (Amazon Web Services, Microsoft Azure, Google Cloud Platform)At least 1 year of experience with CI/CD, Git version control and JenkinsPreferred Qualifications: Master's Degree3+ years of experience with Python, Bash, or Java2+ years experience in Unix/Linux shell scripting2+ years of experience with SQL Developer or Toad2+ years of experience with coding and deployment (Python, Github and CI/CD)2+ years of experience working with Agile Development PracticesAt this time, Capital One will not sponsor a new applicant for employment authorization for this position.The minimum and maximum full-time annual salaries for this role are listed below, by location. Please note that this salary information is solely for candidates hired to perform work within one of these locations, and refers to the amount Capital One is willing to pay at the time of this posting. Salaries for part-time roles will be prorated based upon the agreed upon number of hours to be regularly worked.New York City (Hybrid On-Site): $118,700 - $135,400 for PA, Database AdministratorCandidates hired to work in other locations will be subject to the pay range associated with that location, and the actual annualized salary amount offered to any candidate at the time of hire will be reflected solely in the candidate's offer letter.This role is also eligible to earn performance based incentive compensation, which may include cash bonus(es) and/or long term incentives (LTI). Incentives could be discretionary or non discretionary depending on the plan.Capital One offers a comprehensive, competitive, and inclusive set of health, financial and other benefits that support your total well-being. Learn more at the Capital One Careers website. Eligibility varies based on full or part-time status, exempt or non-exempt status, and management level.This role is expected to accept applications for a minimum of 5 business days.No agencies please. Capital One is an equal opportunity employer committed to diversity and inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to sex (including pregnancy, childbirth or related medical conditions), race, color, age, national origin, religion, disability, genetic information, marital status, sexual orientation, gender identity, gender reassignment, citizenship, immigration status, protected veteran status, or any other basis prohibited under applicable federal, state or local law. Capital One promotes a drug-free workplace. Capital One will consider for employment qualified applicants with a criminal history in a manner consistent with the requirements of applicable laws regarding criminal background inquiries, including, to the extent applicable, Article 23-A of the New York Correction Law; San Francisco, California Police Code Article 49, Sections 4901-4920; New York City's Fair Chance Act; Philadelphia's Fair Criminal Records Screening Act; and other applicable federal, state, and local laws and regulations regarding criminal background inquiries.If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation, please contact Capital One Recruiting at 1-800-304-9102 or via email at [email protected]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.For technical support or questions about Capital One's recruiting process, please send an email to [email protected] One does not provide, endorse nor guarantee and is not liable for third-party products, services, educational tools or other information available through this site.Capital One Financial is made up of several different entities. Please note that any position posted in Canada is for Capital One Canada, any position posted in the United Kingdom is for Capital One Europe and any position posted in the Philippines is for Capital One Philippines Service Corp. (COPSSC).

Required Skills:Bachelors Degree5+ years experience in database administrationStrong background in data warehouse management and data integrationExpertise in Microsoft SQL ServerExperience with Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)Skilled with Power BI and other business intelligence toolsProven experience in data visualization and dashboard creationStrong understanding of ETL processes, performance tuning, and SQL query optimizationExperience with cloud technologies (Azure) and managing hybrid database environmentsDesired Skills:Experience working in fast past/high demand environmentsExperience supporting implementation and post-implementation troubleshootingDescription of Role/Responsibilities:We are seeking an experienced Database Administrator to oversee the performance, integrity, and security of all databases. The person in this role will play a key part in the management and maintenance of both on-prem and cloud databases. This role will be responsible for building enterprise data lakehouse and warehouse, establishing robust data connections, and creating data gateways across multiple sources. This role will work closely with system engineers, data analysts, and project managers. If you are a strong DBA and team player looking for a new role with an outstanding organization this could be the perfect opportunity!Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: https://jobs.beaconhillstaffing.com/eeoc/Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.Company Profile:Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.Learn more about Beacon Hill Staffing Group and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.beaconhillstaffing.com .We look forward to working with you.Beacon Hill. Employing the Future (TM)