- Microsoft SQL Server
Are you interested in the opportunity to work for an industry-leading company whose work with cutting-edge technology is driven by something human: the lives our technology protects? If so, Northrop Grumman may be the place for you. It's not the systems that drive us: it's the soldier our systems bring home. It's not just the technology that motivates us: it's the people for whom our technology enables care. It's not the innovation that gets us up in the morning: it's whom those innovations serve. We're united by our work to help people and protect the world. And that mission makes our team even stronger.
When you join Northrop Grumman, you'll have the opportunity to connect with coworkers in an environment that's uniquely caring, diverse, and respectful. Employees share experiences, insights, perspectives, and creative solutions with some of the best minds in the industry. We collaborate through integrated product teams, cross-functional teams, and employee resource groups, while thriving through the support of training and development, mentors and every day coaching, along with extensive health and work/life benefits. We're committed to our employees' professional and personal development and success.
Northrop Grumman recruits top talent with traditional and non-traditional backgrounds in order to ensure our team is united, connected, skilled, focused and innovative. An inclusive workplace of people with diverse backgrounds, experiences, and perspectives is the key to our performance. At Northrop Grumman, we want our employees to bring their whole self to work. All your different sides are welcome here, as we believe they make our team, our products and our services, that much better.
This position will be located in Providence, Rhode Island.
Roles and Responsibilities:
The qualified applicant will be involved in all phases of software development life cycle (SDLC), from requirements gathering, analysis and design, development, testing, implementation, and production support. In addition to performing software development, the Developer will be will be involved in technical design, database development, documentation, interfacing with other development efforts, and implementations.
Implements and maintains smooth operation and physical design of databases.
SQL Development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, indexes and constraints)
Conducts performance tuning of indexes and databases in general.
Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements.
Manage database security, create users and set appropriate permissions and monitors transaction activity and utilization.
May develop stored procedures and/or triggers.
Trouble-shoot poor performing stored procedures, tune database & query performance.
Support and perform ETL operations from various data sources.
Create & review databases and coordinate changes during deployment.
Provide support and guidance to Application Developers in creation of stored procedures and other database objects to ensure quality and high performance.
Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
Develop solutions to problems of unusual complexity which require a high degree of ingenuity, creativity, and innovativeness. Challenges are frequently unique and solutions may serve as precedent for future decisions.
Serves as prime consultant and external spokesperson for the organization on highly significant matters relating to policies, programs, capabilities, and long-range goals and objectives
To be considered for this position, you must minimally meet the knowledge, skills, and abilities listed below:
Bachelor's degree in Computer Science or related field with a minimum of 10 years of experience.
8 years of experience with data modeling, and experience with querying relational databases such as Oracle and SQL Server
Ability to respond effectively to changing events and competing priorities
Ability to work independently and in a team environment
Advanced knowledge of Microsoft SQL Server.
Experience trouble-shooting query performance.
Strong Knowledge of Agile and related tracking tools e.g. CA Agile Central
Knowledge of third party DBA tools and applications (e.g. Erwin, ER Studio)
Must be a US Citizen or a Green Card Holder
Candidates with these desired skills will be given preferential consideration:
Knowledge of RI UHIP culture, mission, and IT environment.
Experience with CI/CD processes and DevSecOps
Strong interpersonal and consultative skills
Proven project planning experience
Development experience or knowledge in Extended Markup Language (XML).
Experience working in a government contracting environment
Some experience in reporting (SSRS, Crystal Reports or one of the other BI tools).
Northrop Grumman is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. For our complete EEO/AA and Pay Transparency statement, please visit www.northropgrumman.com/EEO. U.S. Citizenship is required for most positions.