We provide IT Staff Augmentation Services!

Sql Database Engineer Resume

Arlington, VA

TECHNICAL SKILLS

  • Install, configure, upgrade, maintain and migrate SQL server databases
  • Build window serves and configure virtual storage disks
  • Extensive experience in using all types of SQL server constraints, SQL server database design, databases maintenance, developing T - SQL queries, stored procedures, views, indexes and SQL Dynamic View(DMV) using SQL Servers
  • Design, implement, and manage complex database cluster environments including SQL AlwaysOn Availability Group(AG), HA, and Disaster Recover Solution(DRS)
  • Create and deploy Drill Down, Drill Through SSRS report, Ad-hoc Report, dashboard and Cascaded Parameterized reports
  • Design, implement, and manage ETL, SSIS and SSAS
  • Provide SQL server databases backup and restore strategy
  • Proficiency with Window server and SQL server database
  • Debugging, monitoring, troubleshooting, and conducting performance tuning for BI solutions and SQL server environment
  • Create and develop detailed design, relational database data modeling and requirements documents for SQL Server environment
  • Configuring and administering windows server 2016/2012
  • Basic understanding skills of Python, Oracle, Power script, and NETBEAN,
  • Implement and support software upgrade and patch management procedures design
  • Implement data warehouse concepts such as star schemas, snow flake schemas, operational data stores and data warehouses
  • Experience with WebSphere DataPower SOA Appliances
  • Configuring WSP, MPGW Services in DataPower. Implemented WS Security, SSL
  • Strong customer service orientation and problem solving skills
  • Basic skills of SAN, RAID, LAN, DSN, DHCP, WAN, and IP concepts
  • Implementing of System Development Life Cycle, Agile life-cycle project
  • Proficiency with Microsoft Access Database and excel
  • Setup and manage user accounts through Active Directory
  • Implement DISA Security Technical Implementation Guides (STIG) on Window servers and SQL Server environment
  • Perform and maintain SQL server databases storage disk.
  • Proficiency with Visio, Veeambackup, Solarwind, VMWare, VCenter and Team Foundation Server (TFS)
  • Good communication and interpersonal skills
  • Ability to work independently as well as part of a team and handle multiple projects simultaneously

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

SQL Database Engineer

Responsibilities:

  • Install, configure, upgrade, and maintain SQL Server 2012,2014, 2016
  • Implement and maintain smooth operation and physical design of databases. Conduct performance tuning of indexes and databases in general,
  • Provide backup recovery and makes recommendations regarding enhancements and/or improvements for all critical SQL Server instances
  • Assist in Configuring and administering windows server 2016/2012.
  • Configure and manage HA, DRS Window clusters and SQL AlwaysOn, Availability Group(AG), replication, and mirroring
  • Perform necessary security patches every month to our production and pre-production environments
  • Assist SSL certificates to established the secure remote desktop connections
  • Perform and maintain SQL server databases storage disk.
  • Setup and manage user accounts through Active Directory
  • Perform SQL server configurations in compliance with established DISA Security Technical Implementation(STIG)
  • Maintain and perform technical support, database availability groups, daily databases maintenance task, security patches, and performance tune-up to all SQL server databases
  • Performance DISA Security Technical Implementation Guides (STIG) on components for Windows, SQL server
  • Ability to work independently as well as part of a team

Confidential

SQL Developer

Responsibilities:

  • Performed migrating data from unstructured database (IBM Lotus Notes ) to structured database (SQL server database)Performed SQL server database performance-tuning expertise for SQL Server databases.
  • Created SSIS(ETL) packages for moving data between databases
  • Involved in creating complex stored procedures, SQL script, and function according to business requirement
  • Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement using SSRS from OLAP and OLTP data sources and deployed on report server
  • Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, databases maintenance, developing Transact- SQL queries, stored procedures, and indexes using SQL Servers
  • Implemented and supported database software upgrade and patch management procedures
  • Managed MS SQL Server database environments that support transactional data as the backend for numerous applications
  • Designed, developed and maintained appropriately-scaled, effective solutions, including functions and stored procedures, to support data cleansing, migration and reconciliation activity in Microsoft SQL Server T-SQL
  • Demonstrate a strong background in data modelling, data management and data manipulation
  • Provided administration of database systems including installation, upgrades, configuration, monitoring, tuning, and maintenance

Confidential

Data Warehouse Developer

Responsibilities:

  • Created and deployed SSRS report, Ad-hoc Report, and dashboard
  • Designed and implemented ETL processes and data architecture
  • Designed, developed, maintained and published logical/physical data models, entity relationship diagrams
  • Created complex query, Views, Triggers, Indexes, Stored Procedures, User Defined Functions
  • Developed and tested high performing extract, transform, cleanse, and load processes in real time
  • Performed the design and extension of data marts, meta data, and data models.
  • Collaborate with Data Modelers, Business Analysts and Application Analysts to identify and understand source system data, business requirements, and the data warehouse data model.
  • Implemented map source system data to the data warehouse models.
  • Define and capture metadata and rules associated with ETL processes.
  • Conceived analytics and business intelligence platform architecture for clients, including internal and third-party clients
  • Adapted ETL processes to accommodate changes in source systems and new business requirements.
  • Monitored performance of ETL processes and develops improvement goals as needed.
  • Consolidate and optimize available data warehouse infrastructure.
  • Supported the analysis of requirements, design specifications, development, and technical and user documentation of report development through direct interaction with internal customers

Confidential

Information Systems Analyst

Responsibilities:

  • Created, build, and maintained database objects (Forms, Queries, Reporting, Macros, and Modules).
  • Developed several access databases from excel spreadsheet.
  • Examined the performance of the system and make adjustments as required and modify it and look for faulty in the programs.
  • Provided Budget formulation and execution.
  • Assisted in configuration, installation, and troubleshooting of application.
  • Created, maintained, evaluated and updated database integrity and security settings.
  • Created documentation on how these databases worked.
  • Prepared training and technical manual for users.
  • Assisted users in implementing new system modules and updating existing modules.
  • Collected user’s requirement and incorporate them into database.
  • Created and modified SQL server database according to the requirement.
  • Created SQL jobs and also maintain the jobs as daily basis as well as weekly basis..
  • Created snapshot replication and transactional replication in the SQL Server 2012.
  • Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
  • Monitored MS SQL Server performance and network issues.

Confidential

WebSphere Datapower Developer

Responsibilities:

  • Created Application Domains, objects like Web Service proxies, Multi-Protocol Gateways as per the requirements.
  • Generated keys, CSRs and self-signed certificates using Crypto tool.
  • Created Crypto profiles, SSL proxy profiles as part of SSL implementation.
  • Configured WSP, MPGW Services in DataPower. Implemented WS Security, SSL
  • Created Load Balancer Groups to load balance the requests to multiple back end points.
  • Created AAA policies to authenticate and authorize user requests using LDAP.
  • Developed and configured WSDL and XML proxies.
  • Experience in working with multiple development and infrastructure teams.
  • Performed general operation tasks such as Firmware upgrade, User management, capacity planning
  • Developed Message flows to transform messages from XML to COBOL copybook format.
  • Worked on XSLT and used XML Transformation node to transform an XML message to another form
  • Active participant in monitoring the middleware and Perform daily on call tasks (checking error logs, Fail over queues, System Logs, Backed out messages) to maintain a healthy system.

Hire Now